Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Bar Chart expression

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

1 Reply
sunny_talwar

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