Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
Showing results for 
Search instead for 
Did you mean: 

Last 6 Months Data Trend in Bar Chart

Hi Friends,

I need formula to get last 6 months data trend in Bar Chart

For Example 

If user will select Feb 2020, The trend should show last 6 months data from Feb 2020 to Aug 2019


Aug 2019 should be sum of (Feb 2019 to July 2019)

Sep 2019 Should be Sum of (March 2019 to Aug 2019) and so on

I have attached excel file  which shows required output in numbers. But output must be in Bar Chart




Thank you

Labels (3)
0 Replies