topic Re: Hidden Field in Current Selection Box in QlikView

Hidden Field in Current Selection Box

Mon, 10 Mar 2014 05:28:35 GMT

Hi,

I'm currently debugging my data model and I need to view the selection of my hidden field. Is it possible to view the hidden field selection in a current selection box. Or do we have other workaround? Thanks!

Re: Hidden Field in Current Selection Box

tresB — Mon, 10 Mar 2014 05:36:09 GMT

If you mean 'conditionlly hidden', conditionally hidden field selection is visible in the current selection box. If you want to view the object, then goto the sheet->right click ->properties->object->show mode (you will find 'conditional: hidden')-> select the object->properties, and then change the condition to set it to a true value.

Re: Hidden Field in Current Selection Box

NareshGuntur — Mon, 10 Mar 2014 05:37:59 GMT

Hi Khim,

Is it hidden using hidesuffix or hideprefix functionality?

If so, go to select fields(under Sheet Properties) and check the Show System Fields in the left bottom which will show the hidden fields.

Cheers,

Naresh

Re: Hidden Field in Current Selection Box

Mon, 10 Mar 2014 08:12:03 GMT

Hi Naresh,

I want to know what are selected in the hidden field. (not adding the hidden field listbox)

Re: Hidden Field in Current Selection Box

Mon, 10 Mar 2014 08:25:00 GMT

Nope... not the show mode. As mentioned by Naresh below, it is the hidden field with prefix. But I want to check the selected value of the hidden field. I have edited my first post with an image example.

Re: Hidden Field in Current Selection Box

tresB — Mon, 10 Mar 2014 08:33:55 GMT

Alternate way:

In a textbox, expression : =GetFieldSelections(_InvoiceNo)

Re: Re: Hidden Field in Current Selection Box

NareshGuntur — Mon, 10 Mar 2014 10:09:39 GMT

Follow my screenshot.

When you enable the System fields, the fields which are hidden(also the selection will not be shown in the current selection box), all the hidden fields will be visible and so you'll be able to see the selections applied to those fields from the current selection box. Hope it is clear.

Cheers,

Naresh