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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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?