Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Thanks Jagan,
It Worked