2017vS2016

master_student — Fri, 20 Oct 2017 09:23:38 GMT

Hello Guys,

I have a variation expression that compares year 2017 VS 2016 until today -1

The problem is that counts all values of 2016 including values where date is > today -1 ; the variation becomes false, any idea how to change this expression so it will compare values until 20 october of the two years

I hope I am clear. Here is my expression :

=num((num(sum( {$<[Year of date]={$(=Max([Year of date]))}>} recharge_amount),'# ##0') // 2017

- num(sum( {$<[Year of date]={$(=Max([Year of date])-1)}>} recharge_amount),'# ##0')) //2016

/ num(sum( {$<[Year of date]={$(=Max([Year of date])-1)}>} recharge_amount),'# ##0') *100,'# ## % ') //2016

Thanks in advance for your help

Re: 2017vS2016

Mark_Little — Fri, 20 Oct 2017 09:42:08 GMT

I would Normally approach a probably like this in Script.

I add flags to my calendar for periods I am interested in.

Like below

IF(YEAR(TempDate)= YEAR(ADDYEARS(TODAY(1),-1)) AND TempDate <= ADDYEARS(TODAY(1),-1),1) AS F_CAL_LYD,

The use the set analys

SUM({<F_CAL_LYD={1}>}Amount).

But in set analysis you can use something like

SUM({<DATE={'>=$(YEARSTART(ADDYEARS(TODAY(),-1))),<=$(ADDYEARS(TODAY(),-1)))'}>})

Mark

topic 2017vS2016 in QlikView

2017vS2016

Re: 2017vS2016