Bar Chart expression

bharatkishore — Fri, 18 Aug 2017 12:41:51 GMT

Hi All,

I have a bar chart. There i have written an expression that the bars should be from the starting month to the selected month.

If i have data from Jan 2016 if i clicked april 2017 the graph should be from Jan 2016 to April 2017.

Now the problem is i need to calculate the sum for the years. For example if i select 2017 april i need so calculate Jan 2017 sum to April 2017 sum, if i select 2017 March means i need so calculate Jan 2017 sum to Mar2017 sum. if i select 2017 Feb means i need so calculate Jan 2017 sum to Feb2017 sum. The data for Jan 2016 to Dec will be same.

For more reference i am attaching my qvw.

Please let me know if you require anything more.

Note: Defaulty there will be always one selected month in list box

Thanks,

Bharat

Re: Bar Chart expression

sunny_talwar — Fri, 18 Aug 2017 12:44:22 GMT

There is no year field in your attached application... where do you plan to select year 2017?

topic Bar Chart expression in QlikView

Bar Chart expression

Re: Bar Chart expression