Auto Create List of Tables and Fields and exclude specific columns

[#1]

Hi,

I am trying to customize an advanced Filter shown in the following QlikView Flat Design QVW posted by Richard Pearce.

QlikCentral Flat Design QVW template

In My Application I have hidden certain field from Users by using Hide Prefix in load script as '@' symbol.

What kind of IF statement should write so that I can achieve following..

I do not want fields starting with '@' to appear in the advanced filter because they are just foreign and primary keys which has no use to the end user.

[jagan · Accepted solution]

Hi,

Modify the below code in script ADVANCED FILTER tab

For Each vTable in 'Customers','Orders','OrderDetails (Sales)','Products','Employees'

  For vCurser = 1 to NoOfFields('$(vTable)');

  LET vFieldName = FieldName(vCurser,'$(vTable)');

  IF Left(vFieldName, 1) <> '@' THEN

       DI_AdvancedFilters:

       Load

            '[$(vFieldName)]' As %AF_FeildName

            ,'$(vTable)' As %AF_TableName

       AutoGenerate 1;

END IF;

  NEXT vCurser

NEXT vTable

Hope this helps you.

Regards,

Jagan.

[#3]

Thanks Jagan,

It Worked