topic Re: How I lock a chart display based on Quarter selection? in QlikView

How I lock a chart display based on Quarter selection?

Fri, 12 Jun 2015 04:48:28 GMT

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.

Re: How I lock a chart display based on Quarter selection?

Anonymous — Fri, 12 Jun 2015 06:57:28 GMT

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

Re: How I lock a chart display based on Quarter selection?

Fri, 12 Jun 2015 06:58:51 GMT

Hi,

Check the Alternate states concept.PFA

Re: How I lock a chart display based on Quarter selection?

Fri, 12 Jun 2015 07:02:18 GMT

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

Re: How I lock a chart display based on Quarter selection?

Fri, 12 Jun 2015 15:07:32 GMT

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

Re: How I lock a chart display based on Quarter selection?

Fri, 12 Jun 2015 22:01:56 GMT

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