How to remove hidden fields while using system fields

[varunreddy]

Hi All,

I am trying to hide few fields in the QlikView application.

This is working fine.

Now I created a list box with "$Field" as expression. Now this is also showing the hidden fields.

I have attached the excel file and the QVW.

Here I have 3 fields A,B&C. I am hiding A. But I am seeing when I show $Field.

Can anyone help me how to get rid of hidden fields?

Thanks in advance!

[vishsaggi · Accepted solution]

May be try this.

I cant use your Test.qvw as I am using personal edition.

So i assume you used HidePrefix to hide your column.

SET HidePrefix = '%';

LOAD A  AS %A,

           B,

           C

From yourpathfilename;

Then when you add $Field in the listbox, do not use this $Field, just write an expression like

= IF(WildMatch($Field, '%*'), Null(), $Field)

So this will hide the fields with %prefix. Change your character accordingly.

Hope this helps.

[varunreddy]

Thanks Vishwarath for your quick turn around.