Hide values

[soniasweety]

Hi All,,

i have two listboxes typeA and typeB    

i want to hide the non associated values in listbox.  how to do    vice versa in two listboxes? 

Thanks

Sony.

[tresesco]

General tab -> Hide excluded

[OmarBenSalem · Accepted solution]

instead of using as filters :

Dim1 and Dim2

Create 2 calculated filters as follow:

aggr(only({<Dim1=p(Dim1)>}Dim1),Dim1)

aggr(only({<Dim2=p(Dim2)>}Dim2),Dim2)

This will work; BUT you won't be able to include these into your set analysis.

I mean, if u have an expression as follow:

Sum({<Dim1>}Measure) : supposed to give back the sum of measure for all the Dim1 Values even if u select one or few values of Dim1

But, with ur new filter, if u use it to make a selection, ur measure will respond to ur filter and thus show only the values u've selected...

Hope that's clear.

The best approach is to convince the one asking you to not show the alternative/excluded values, that this is kind of a "stupid" request.

[OmarBenSalem]

**bleep** 😄 I thought this was a qlik sense topic !

[soniasweety]

yes i used the same.but if i use hide excluded i can see grey empty space in the listbox...user dont want to see grey colur when it hide

[tresesco · Accepted solution]

In that case try using expression in the list box instead like:

Aggr(Field1, Field1)

[soniasweety]

thanks both solutions is working but

one listbox we have default selection in TypeA so when i open the dashboard user able to see only one value.. how user know that in that listbox two values are there?