topic Re: Hide values in QlikView

Hide values

soniasweety — Sat, 16 Nov 2024 04:59:06 GMT

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.

Re: Hide values

tresB — Wed, 12 Dec 2018 09:18:59 GMT

General tab -> Hide excluded

Re: Hide values

OmarBenSalem — Wed, 12 Dec 2018 09:19:44 GMT

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.

Re: Hide values

OmarBenSalem — Wed, 12 Dec 2018 09:20:20 GMT

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

Re: Hide values

soniasweety — Wed, 12 Dec 2018 09:30:10 GMT

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

Re: Hide values

tresB — Wed, 12 Dec 2018 09:32:49 GMT

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

Aggr(Field1, Field1)

Re: Hide values

soniasweety — Wed, 12 Dec 2018 09:39:55 GMT

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?