Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishpalkar
Creator III
Creator III

Show all hidden field in Listbox

Hi There

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

Thanks in advance,

18 Replies
sunny_talwar

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Luminary Alumni
Luminary Alumni

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
Creator III
Creator III
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Luminary Alumni
Luminary Alumni

Good point.  Thanks Rob.

dgreenberg
Luminary Alumni
Luminary Alumni

Woops actually it would be

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

But rob is correct about the tagged fields.

ashishpalkar
Creator III
Creator III
Author

Hi Rob

Please find my attached example QVW.

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

thanks again..