topic Re: Alternate States in QlikView

Alternate States

dathathreya — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Alternate States

sunny_talwar — Thu, 01 Jun 2017 12:39:42 GMT

Can you attach your qvw?

Re: Alternate States

micheledenardi — Thu, 01 Jun 2017 12:47:27 GMT

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-comparison-chart-part-two/