topic Re: How to remove hidden fields while using system fields in QlikView

How to remove hidden fields while using system fields

varunreddy — Thu, 22 Feb 2018 06:12:55 GMT

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 — Thu, 22 Feb 2018 06:29:47 GMT

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,

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 — Thu, 22 Feb 2018 06:36:26 GMT

Thanks Vishwarath for your quick turn around.