Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Newbie to QV and am trying to find my way around
Case 1
I have two charts
Chart A which has 3 different expressions built on Measure A and Dimension Day
Chart B which has 3 different expressions built on Measure B and Dimension Day ( the same as above)
Now I want a user to be able to flip between these two charts in the same view.
Is that even possible - I am on QV 11 if that makes any difference,
Case 2
I have Chart C which displays MTD figures for Measure A with Dimension Day for a chosen month,
Now when the user chooses a quarter - I want to show the Measure A QTD figures with the Dimension Quarter
Now when the user chooses a year - I want to show the Measure A YTD figures with the Dimension Year
I have the three charts separately - but how do I combine them in one view ?
Would appreciate if anyone can point me in the right direction.
Thanks in advance,
What I am trying to do (which was not made clear, sorry) is flip between two different charts that each have multiple expressions.
No one has an answer ??
The easiest way is to add your charts to a container object. The user can then easily switch between the charts.
Thanks Gysbert - this solves my Case A.
In Case B - I am using the master calendar (http://community.qlik.com/docs/DOC-6593) and want to show the appropriate chart.
I tried the Hierarchical Group - doesn't seem to work.
Any thoughts ?
Thanks DV - will check and revert
You can add all expressions to the same chart. Then add expressions for the Conditional option to show/hide the expressions depending on the selections of the user. You can use the getselectedcount() function to check if the user made a selection in a field. To show/hide the YTD expression you could use something like =if(getselectedcount(Year)>0,1,0). If the user selects a value in the field Year then the count will be larger than 0 and the conditional expression will return 1 (i.e. True) so the expression values will be shown in the chart.