How I lock a chart display based on Quarter selection?

[#1]

I created Pareto chart for our customers and they love it. But they would like to compare Pareto principle by quarter and see the difference between each quarter.

Here my objective is display 4 different quarters in 4 different bar charts (preferably my customer choose the quarter in each chart and lock it). Is it possible?

As of now all charts are changing simultaneously or I was not able compare the data by quarter.

Thanks bunch for all your help. sample .qvw has been enclosed.

[Anonymous]

SO here you can do this in two way

1. you can give Qtr={Q1} in set analysis first chart

Qtr={Q2} and so on .

like =count{1<Qtr={'Q1'}>Col1}  in expression (May be other condition as well)

2. You can use alternate states for all the four charts .

Thanks

BKC

[#3 · Accepted solution]

Hi,

Check the Alternate states concept.PFA

[#4]

Hi,

Will it be ok if each chart displays data for each quarter?So the user can see the data for all the quarters at one view.

Please find the attachment.

Regards,

Jemimah

[#5]

Works great. But after my selection, it is not responding to left side filters. Thanks

[#6]

@navdeep Kumar...Thank you so much for your help. It worked us for good.