Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SatyaPaleti
Creator III
Creator III

How to do Hide Excluded in Qliksense when always one select option enabled

Hi Everyone,

Can we achieve Hide excluded in Qliksense? I am implementing aggr(field,field) and its hiding excluded but  when "we have an always one select option enabled" we are getting only selected value but it have to show all the possible values. How it can be possible

Thanks,

Satya

Labels (1)
2 Replies
hic
Former Employee
Former Employee

If you use "Always one selected value", then there is only one value that is possible - the selected value. The other values are indeed excluded.

So, if you want to hide the excluded values, you can use either
=Aggr(Field, Field)
or
=Aggr(Only(Field), Field)


And, if you want to show the excluded values, you can use either a naked field reference
=Field
or the expression
=Aggr(Only({1} Field), Field)

But hiding the excluded values doesn't seem to be a good idea: Then the user cannot change the selection.

SatyaPaleti
Creator III
Creator III
Author

Hi Henric,

Thank you so much for your response on this. Actually we want to hide values of fields which are in highlighted in grey color. There will be values under white background and there will be the values with grey back ground too. we want to hide grey background fields

Thanks,

Satya