Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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