Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a chart with sum(sales) as expression for ex and i have 3 buttons to toggle dimensions for that chart in between 3 different dimensions.
That means, when i select button 1, it should show chart with dimension1 & sum(sales)
when i select button 2, it should show chart with dimension2 & sum(sales)
when i select button 3, it should show chart with dimension3 & sum(sales)
how to get it ?
Hi
just use one variable for all 3 dimensions
variable=1
variable=2
variable=3
What exactly is the issue you are running into? Do you have a sample where we can help you resolve the issue?
Using qsVariable extension you can achieve this, Please have a look at this article about cyclic group in Qliksense
Makes Sense to go round in circles
This will help you in implementing the above mentioned case.
In the above pic, when i click on y-o-y, the chart should display data for dimension field year,
when i click on q-o-q, the chart should display data for dimension field quarter,
when i click on m-o-m, the chart should display data for dimension field month,
Hi,
What about to set Variables for the buttons and use conditions for the Chart expressions?
Can you send a sample?
Hi,
Does the attached help your requirement to change the dimensions of your chart?
Hi Mohan
First you have to create 3 seperate charts with which dimensions and expression
you want,
Secondly add that charts into container.
Next go to settings --> variable overview and create a variable name vShowChart=0,
After Creating the variable, select chart 1 properties go to Layout --> select the Show Conditional and write expression like vShowChart=1 click apply and OK,
Make the same changes like chart 2 & chart 3 expression like a vShowChart=2 & vShowChart=3.
Next create 3 seperate buttons , go to button 1 properties --> Action -->select External --> click Set variable
give variable name= vShowChart and Value =1.
In button 2 properties give variable name= vShowChart and Value =2. and
button 3 properties give variable name= vShowChart and Value =3.
Click apply and OK.
Now if u select the button 1 it will shows chart 1 with chart 1 dimensions , same like others too
Regards
Deepak
This scenario, Good approach could be Sample provider
Dimension needs to change depend on the selection and expressions still same.
I tried by setting variables on buttons and applied those variable conditions in "Enable conditional" for those dimensions
"Dimension needs to change depend on the selection and expressions still same"
So you can create 3 different Charts with different Dimensions and Expressions and use the Conditional Layout to Hide/Show the Chart depending on the selection