2 responses to “Advanced Filters In Flat Design”

1. Will the creation of the data island automatically exclude fields that have a prefix designated as the ‘Hide prefix’ (e.g. % or _)? Or would I need to add a Where statement to explicitly skip over those fields?

   LikeLike

2. Hi Brian,

   That’s a good point, in this example it wouldn’t do that automatically
   You would need to add a conditional ‘IF’ statement around the autogenerate;

   For vCurser = 1 to NoOfFields(‘$(vTable)’);
   LET vFieldName = FieldName(vCurser,’$(vTable)’);

   if left(vFieldName,1)’%’ and left(vFieldName,1)’_’ then

   DI_AdvancedFilters:
   Load
   ‘$(vFieldName)’ as %AF_FieldName
   ,’$(vTable)’ as %AF_TableName
   AutoGenerate 1;

   ENDif

   NEXT vCurser

   Thanks

   PS – I’ve added the QVW to the Qlik comunity now http://community.qlik.com/docs/DOC-7273

   LikeLike