Show all hidden field in Listbox

[ashishpalkar]

Hi There

Is there any way to show all hidden fields of the document  in a List box?

Thanks in advance,

[sunny_talwar]

My bad, did not read the post completely. AFAIK there is no inbuilt capability to do this, may be a Macro.

[rwunderlich]

As Sunny said, there is no function you can use at runtime to determine if a field is hidden. As a bit of a hack, you can load the metadata -- which includes the $hidden Tag -- from the QVW. You can then filter on the '$hidden' tag. I call it a "hack" because you are reading from the qvw on disk, not the in memory qvw that just reloaded. So changes will not be reflected until saved and reloaded. If you are ok with that, see the attached example for how you can load the field metadata and use as filters.

I'm not sure exactly what you are trying to accomplish so I did not create any example listbox to answer your specific question. Let me know if you have additional questions on how to use the metadata,

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[dgreenberg]

If you are talking about hidden fields not system fields you could create a an expression for your listbox like this:

Assuming hideprefix='%'

if(left($Field,1)='%',$Field)

[ashishpalkar]

Thanks Rob for very nice info.. can you guide me on loading metadata?

[rwunderlich]

Ashish,

Please look at the qvw I attached to my previous reply for an example script to load Field Metadata.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[rwunderlich]

Dan,

This will cover fields hidden using HidePrefix. But it won't catch fields that were hidden with a tag:

TAG FIELD xxx WITH '$hidden';

which I find to be fairly common these days.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[dgreenberg]

Good point.  Thanks Rob.

[dgreenberg]

Woops actually it would be

=if(left($Field,1)<>'%',$Field)

But rob is correct about the tagged fields.

[ashishpalkar]

Hi Rob

Please find my attached example QVW.

The hidden fields should be seen in the current selection without changing its name.

thanks again..