topic Re: Last 12 months Line Graph in QlikView

Last 12 months Line Graph

Mon, 21 Sep 2015 14:04:09 GMT

Hi All,

I have a user requirement. He wants to see 12 months trends of particular KPI's in line graph. I have months from Jan to Dec as filter selections. His requirement is when November 2015 is selected, Graph should be plotted from November 2014 to November 2015 i.e trend should be seen from Nov to Nov. When Dec 2015 is selected, line graph should show trend from Dec 2014 to Dec 2015. Likewise when July 2015 is selected, July 2014 to July 2015 to be shown.

How can I achieve this dynamic behavior?

Re: Last 12 months Line Graph

sunny_talwar — Mon, 21 Sep 2015 14:08:24 GMT

Use Set analysis like this:

=Sum({<DateField = {"$(='>=' & Date(AddYears(Max(DateField), -1), 'YourDateFieldFormat') & '<=' & Date(Max(DateField), 'YourDateFieldFormat'))"}>}Sales)

Re: Last 12 months Line Graph

jolivares — Mon, 21 Sep 2015 14:12:20 GMT

This a typical case for use set analysis. In your expression you need say to QV that you need this set of data:

For instance: Sum({<MyYear, MyMonth, MyYeMon={">=$(=Max(MyYeMon)-12)"}>} Sales)

Assuming you have a field containing then plus the month (201511),when the user select November 2015, Qlik search the set of data where month.

Re: Last 12 months Line Graph

Mon, 21 Sep 2015 14:13:02 GMT

Thanks Sunny, I will try.

Re: Last 12 months Line Graph

ecolomer — Mon, 21 Sep 2015 20:47:34 GMT

See this:

Re: Last 12 months Line Graph

triekong — Sun, 14 Jan 2018 08:07:58 GMT

ecolomer‌

thanks for the solution i have done this. i know this thread is old but

But i have a hitch: what if i wanted to display all the Months on the x axis. regardless of if i have data in the months or not.

for example: if March 2017 data = 0, and December 2017 is selected, i still want my chart x axis to read from: Dec2016, Jan2017, Feb2017, March2017,Apr2017, May2017 ,June2017 ,July2017 ,Aug2017, Sept2017, Oct2017, Nov2017 ,Dec2017

Any thoughts on this? !