Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

Can you attach your qvw?

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...