Qlik Community

Ask a Question

App Development

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

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

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

Now

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

Last6monthdata.png

 

 

Thank you

Labels (3)
0 Replies