Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hidden Field in Current Selection Box

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!

hidden.png

6 Replies
tresesco
MVP
MVP

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.

NareshGuntur
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

Hi Naresh,

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

Not applicable
Author

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.

tresesco
MVP
MVP

Alternate way:

In a textbox, expression : =GetFieldSelections(_InvoiceNo)

NareshGuntur
Partner - Specialist
Partner - Specialist

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