topic %Change YOY in QlikView

%Change YOY

vardhancse — Sun, 07 Feb 2016 08:07:49 GMT

Hi,

Have one requirement is that, required one line graph showing the %Change YOY based on the selection of metric.

**Its rolling 12 months based on the year and month filter.

Applied below expression:

Sum({<FYYear=,MonthName=,DateFull={">=$(=MonthStart(Max(DateFull),-12))<=$(=Date(Max(DateFull)))"}>}Actual)

But the requirement was :

Formula = (Current Value – Previous Value) / Absolute(Previous Value)

PFA sample application.

Thanks in advance.

MK_QSL — Sun, 07 Feb 2016 08:26:38 GMT

Like this?

vardhancse — Sun, 07 Feb 2016 09:21:07 GMT

Hi Manish,

Thanks for your reply.

Sorry this is not my requirement.

1.Based on selected month and year, rolling 12 months like graph in terms of %

2. The graph should be %change YOY

Formula = (Current Value – Previous Value) / Absolute(Previous Value)

E.g:

Selected month and year: Jun-2014

Graph should show jun-2014 to back jun-2013.

=(65-60)/60=8.33%

so in graph it should show for jun-2014: 8.33

similarly for all the 12 months back to the jun-2014

MK_QSL — Sun, 07 Feb 2016 09:26:27 GMT

How 65 and 60 is coming for Jun-2014?

Please clarify!

vardhancse — Sun, 07 Feb 2016 09:32:04 GMT

Jun-2014: 65

Jun-2013: 60

**Please note that this is sample data

MK_QSL — Sun, 07 Feb 2016 12:37:43 GMT

Like this?