topic Re: Show all hidden field in Listbox in QlikView

Show all hidden field in Listbox

ashishpalkar — Fri, 12 Feb 2016 21:36:37 GMT

Hi There

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

Thanks in advance,

Re: Show all hidden field in Listbox

sunny_talwar — Fri, 12 Feb 2016 21:42:41 GMT

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

Re: Show all hidden field in Listbox

rwunderlich — Sat, 13 Feb 2016 07:01:58 GMT

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

Re: Show all hidden field in Listbox

dgreenberg — Mon, 15 Feb 2016 13:16:48 GMT

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)

Re: Show all hidden field in Listbox

ashishpalkar — Tue, 16 Feb 2016 15:39:24 GMT

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

Re: Show all hidden field in Listbox

rwunderlich — Tue, 16 Feb 2016 17:09:13 GMT

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

Re: Show all hidden field in Listbox

rwunderlich — Tue, 16 Feb 2016 17:11:01 GMT

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

Re: Show all hidden field in Listbox

dgreenberg — Tue, 16 Feb 2016 17:44:33 GMT

Good point. Thanks Rob.

Re: Show all hidden field in Listbox

dgreenberg — Tue, 16 Feb 2016 17:45:46 GMT

Woops actually it would be

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

But rob is correct about the tagged fields.

Re: Show all hidden field in Listbox

ashishpalkar — Tue, 16 Feb 2016 18:26:48 GMT

Hi Rob

Please find my attached example QVW.

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

thanks again..

Re: Show all hidden field in Listbox

rwunderlich — Tue, 16 Feb 2016 19:24:56 GMT

It sounds like you may be changing your requirement? In your first post you asked about listing hidden fields in a listbox. In the last post you asked about including hidden fields in a current selections box. Could you be more specific about your actual business objective?

-Rob

Re: Show all hidden field in Listbox

ashishpalkar — Tue, 16 Feb 2016 19:29:14 GMT

Hi Rob

listing hidden fields in a list box is first priority but including hidden fields in a current selections box can be workaround too...

Thanks

Re: Show all hidden field in Listbox

ashishpalkar — Tue, 16 Feb 2016 19:40:34 GMT

The main objective behind this is , i have 500+ hidden attributes and these attributes are added in the chart table using conditional show. Users have created bookmarks based on those attributes. Users don't want to re create the bookmarks. Now some user population is looking for functionality to add and remove attributes from chart table with the help of current selection or list box which will have all selected conditional attributes.

Hope this helps...

Re: Show all hidden field in Listbox

ashishpalkar — Wed, 17 Feb 2016 21:15:57 GMT

Hi Rob

Any suggestions?

Re: Show all hidden field in Listbox

rwunderlich — Wed, 17 Feb 2016 22:40:43 GMT

It sounds like you want to display the currently selected values for hidden fields. The only way I can think of is to use

GetFieldSelections(myHiddenField)

-Rob

Re: Show all hidden field in Listbox

ashishpalkar — Thu, 18 Feb 2016 19:57:42 GMT

Hi Rob

thanks for the reply,

Please find attached sample QVW.

Here in this scenario 2 list boxes are created and they are added in container.

Using Chart table attributes are added in the table.. These attributes are conditionally selected.

One more list box created to combine both list boxes into one, (which we had discussed earlier)

Now using the combined list box attributes should be able to select / unselected the report attributes .. means user dont have to go report build menu and search for attributes..

Hope this helps..

Re: Show all hidden field in Listbox

ashishpalkar — Fri, 19 Feb 2016 21:13:22 GMT

Any suggestions?

Re: Show all hidden field in Listbox

rwunderlich — Fri, 19 Feb 2016 23:54:41 GMT

I don't have any suggestions. I'm sorry, I'm not following what you are trying to do.

-Rob

Re: Show all hidden field in Listbox

jepeerik — Tue, 12 Apr 2016 14:35:19 GMT

As far as I understand you, you want a hidden field (by using SET hideprefix in Script) in a Listbox.

This is possible by first adding a new Table object on your dashboard with the option 'Show System Fields' selected. After that you'll see all System Fields and Hidden Fields available in the Listbox and you can select the field you want.