topic Re: show all dimension values based on selections in QlikView

show all dimension values based on selections

Anonymous — Tue, 22 May 2018 08:10:12 GMT

Hi All,

Please find the below table.Country dimension as list box if i selected ALL ,in the pivot table i want to show all countries except ALL otherwise it should show selected country.

country	Sales
ALL	40
IND	20
USA	10
UK	10

Re: show all dimension values based on selections

Anonymous — Tue, 22 May 2018 09:57:47 GMT

Its not the best practice but a quick fix would be to use buttons that make those selections.

Re: show all dimension values based on selections

Anonymous — Tue, 22 May 2018 09:58:08 GMT

country is lower case c

Re: show all dimension values based on selections

olivierrobin — Tue, 22 May 2018 10:05:56 GMT

hello

if Sales for ALL the sum of other countries ?
If Yes, i wouldn't load ALL, and no by the normal qV mechanism, if you don't select anything, you have the total

and if you select a country, you have only this country