Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dathathreya
Creator
Creator

Alternate States

Hi all,

i am facing an issue with the Alternate states.

In the preview of the image three list boxes are there

1) Year

2)Month &

3)Month

Two charts

Bar chart for the sales region wise.

coming to the requirement for 1 month list box i have given StateA,and for that related barchart also stated as StateA,the other month is StateB and related barchart is stateB.

Now in year list box i have mention the default state .

As per thing by selecting the year the both states A,B has to show the variation ,But it is not showing.

Can any one plz help me in this.

Thanks in Advance.Alternate.PNG

2 Replies
sunny_talwar

Can you attach your qvw?

micheledenardi
Specialist II
Specialist II

Try to use use SetAnalysis:

sum({StateA}  <Year=$::Year> Sales) for the first chart

sum({StateB}  <Year=$::Year> Sales) for the second chart


https://www.resultdata.com/using-multiple-alternate-states-combined-with-set-analysis-to-create-a-co...

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.