topic Re: variation until today in QlikView

variation until today

master_student — Wed, 11 Oct 2017 07:52:11 GMT

Hello Guys,

In the graph bellow, I am comaring the recharge amount 2016 Vs 2017 and I am calculating the variation 2017 par rapport 2016

value 2017 - value 2016 / value 2016 *100 , the problem is whene the selected month is october , the variation is false because the rest of value of october 2017 are not yet available. so i need to display the variation to be until today whene the month is october, any idea ?

the variation expression :

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

Thank you so much

Re: variation until today

Anil_Babu_Samineni — Wed, 11 Oct 2017 10:38:14 GMT

This?

If(GetFieldSelections(MonthField) = 'October',

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

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

Re: variation until today

sunny_talwar — Wed, 11 Oct 2017 11:55:52 GMT

You can use set analysis to restrict your chart to show up until today...what is your date field called here? and what is it's format?

Re: variation until today

master_student — Wed, 11 Oct 2017 13:18:44 GMT

sunny‌

my date dimension is : Date(SetDateYear([Calendar date], Year(Today())), 'DD/MM')