topic Re: Auto Create List of Tables and Fields and exclude specific columns in QlikView

Auto Create List of Tables and Fields and exclude specific columns

Mon, 22 Feb 2016 23:12:04 GMT

Hi,

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

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.

Re: Auto Create List of Tables and Fields and exclude specific columns

jagan — Tue, 23 Feb 2016 01:25:01 GMT

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.

Re: Auto Create List of Tables and Fields and exclude specific columns

Tue, 23 Feb 2016 01:28:09 GMT

Thanks Jagan,

It Worked