topic Re: Update chart based on List bax selection?? in QlikView

Update chart based on List bax selection??

soha1902 — Fri, 16 Jan 2015 09:44:43 GMT

Hi All,

I have one Year list box filter in my dashboard which shows the Fiscal Years.

In one of Pivot table I am displaying future stock of product in weekly basis and uses the standard date.

like below

Product	11/3/2014	10/3/2014	17/3/2014	24/3/2014	12/1/2014	12/8/2014	12/15/2014	12/22/2014	12/29/2014

Now the Problem is If I select 2014 from Year filter then it will showing 2014 and 2013 data in Pivot table, if I select 2015 then it is showing 2015 and 2014 data and so on. I want if select 2014 then in pivot table it will show only 2014 data and so on.

I want to do this in UI level only. Please help me to resolve this.

Thanks..

Re: Update chart based on List bax selection??

Gysbert_Wassenaar — Fri, 16 Jan 2015 09:47:24 GMT

Add a list box with an expression =Year(MyStandardDate) and make selections using that list box instead of using the Fiscal Year. Replace MyStandardDate with the name of your standard date field name.

Re: Update chart based on List bax selection??

soha1902 — Fri, 16 Jan 2015 09:54:56 GMT

Thanks for your reply. In my application multiple tabs are available and I am using the same Filters in all the tabs, So can not change the Year field value in one tab only. Can you please suggest any other way to do this.