Is it not possible to add a document/sheet action that selects value from a hidden field(with leading undescore _)?

[ol_dev]

Hi, we are in the process of porting a Qlikview app to Qliksense cloud, though we are running into a problem right now. On our qlikview app, we have a document trigger/action which automatically selects possible value(s) for some certain fields, with a few of them being hidden fields(leading underscore fields such as _UserTypeID and _GranteeID). We are unable to emulate this behavior on Qliksense, as the sheet actions will only allow us to choose non-hidden fields. Is this a limitation from Qliksense that we cannot bypass? And if so, what are the workarounds that we can use? Thanks. 

 

[rubenmarin]

Hi, there is an idea for this: https://ideation.qlik.com/app/#/case/280111?currentProductId=9da99bc1-0dfb-4471-8e12-d23685578c43&se...

Maybe you need to authenticate here first: https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight

[anat]

First you apply sheet access without '_'  field then later you can use HidePrefix then automatically it will take _field

i can see _ fields in Nov2023 verson

can you checck which version you are using

[ol_dev]

Hi, I am using the May 2023 version and it does not show any fields with leading underscore(_). I am not aware of any major updates made in the latest version though, but I am willing to give a try. With this being said, what do you mean by applying sheet access without _ field? 

[vinieme12]

Is this a limitation from Qliksense that we cannot bypass? 

This is not a limitation but by design; your use case seems counter to the purpose of hidden fields.

Why hide fields you want to make selections on! 

[ol_dev]

Hi, the field is not supposed to be selected by clients, but it is set automatically with certain user actions. We'd like it to be possible to use the hidden field _UserTypeID when the user first loads the app, and when some certain actions are triggered. But of course, it is not supposed to be directly selectable. 

[ol_dev]

Back to the topic, I have not yet been able to resolve this issue. I dont understand why it is possible to achieve this in Qlikview but not in Qliksense, if what @vinieme12 said it was not a limitation but by design. Apparently it is possible to specify onOpen triggers in Qlikview. I think this is because Qlikview allows selecting fields in a trigger using expression, while Qliksense does not. 

Also if I will change the hidden field to non-hidden field, they will show up in the selection list above the sheet. I tried to untick the checkbox for 'Show selection toolbar', and it does not seem to work. Is there really no way I can work around this issue? 

[luciancotea]

Have you tried to set up the action before setting the 'HidePrefix' variable?

If not, try using an extension that has actions, like the 'SimpleList'.

[luciancotea]

There are cases when you want to hide the 'technical' fields you use in your app (various mechanisms), leaving the selection bar for the actual user selections.

For example, the selected currency or language.

[ol_dev]

@luciancotea I am a little bit confused what you meant by setting up the action before setting the  'HidePrefix' variable? Do you mean something like this suggested in another thread(Set up the action first, then hide the field)? Honestly I have no idea how to achieve this either, even though I've heard it being talked about before. 

https://community.qlik.com/t5/Suggest-an-Idea/Button-chart-can-t-select-Hidden-Fields/idc-p/2032788/...