topic Re: Dimension based on selection in QlikView

Dimension based on selection

livetolearn — Fri, 22 Jan 2021 05:45:49 GMT

Hi All,

I just wanted to know how do i change the dimension of a table or bar chart ,

Example : I have a bar chart with dimesion "Region" and expression as Sum(Sales) .

Now I want to have a list box as variable in (0 and 1) if I select 1 then the table should show Dimesnion as "Country"

and If 0 then the table chart should show "Region ".

Is this possible to make the table or bar chart change the dimesions according to the selection from the list box ?

Thanks

MayilVahanan — Fri, 22 Jan 2021 06:04:34 GMT

Try like below

=If(vUserInput = 1, Country, Region)

livetolearn — Fri, 22 Jan 2021 06:19:09 GMT

I created the variable vUserInput and in definition I assigned one ,

And in the dimension i mention your above mentioned expression ,

But the thing is how do i make the selection 1 or now selection in a list box ?

And also the header of the dimesion should change if its Region or Country ?

I am stuck on this

MayilVahanan — Fri, 22 Jan 2021 06:39:27 GMT

Create a listbox using inline or create dropdown list box.

Load * inline

[

UserInput

];

and make it "Always one selected value".

In dim expression,

=If(UserInput = 1, Country, Region)

Label: =If(UserInput = 1, 'Country', 'Region')

Hope it helps