Advanced Filters In Flat Design

To continue a series of post on QlikView Flat design here I talk you through the functionality of the advanced filters

 

https://www.youtube.com/watch?v=v5UtAFkeXzU

 

Note: I’ve recorded the videos in highest resolution possible. So please view them in 1080 or 720P (HD) for best quality. Cheers!

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?

    Like

  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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s