Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ol_dev
Contributor III
Contributor III

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

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. 

 

ol_dev_0-1707508593907.png 

ol_dev_1-1707508689827.png

 

 

Labels (1)
9 Replies
anat
Master
Master

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

anat_0-1707567401222.png

can you checck which version you are using

 

ol_dev
Contributor III
Contributor III
Author

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
Champion III
Champion III

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! 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
ol_dev
Contributor III
Contributor III
Author

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

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
Specialist
Specialist

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
Specialist
Specialist

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

@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/...