topic Re: Last Year in QlikView

Last Year

qlikviewaf — Wed, 06 Sep 2017 13:08:23 GMT

Hi Guys,

on my app i select Year/Month to see the sales.

I would like also to retrieve the sales for the same month of last year.

There's a way to say in the formula to keep data of last year based on the year selected?

So if i select 2017 the formula will retrive 2017-1= 2016 ? Is something possible?
Thanks

sum({<Area-={'Area-not-available'}>}ExtendedUSD),

sunny_talwar — Wed, 06 Sep 2017 13:11:38 GMT

May be like this

Sum({<Area-={'Area-not-available'}, Year = {$(=Max(Year) - 1)}>}ExtendedUSD)

its_anandrjs — Wed, 06 Sep 2017 13:12:19 GMT

You can try this way

Current Year

sum({<YearField = {"$(=Max(YearField))"}, Area-={'Area-not-available'}>}ExtendedUSD)

Previous Year

sum({<YearField = {"$(=YearField-1)"}, Area-={'Area-not-available'}>}ExtendedUSD)

sum({<YearField = {"$(=Max(YearField)-1)"}, Area-={'Area-not-available'}>}ExtendedUSD)

qlikviewaf — Wed, 06 Sep 2017 13:24:02 GMT

Tried without success

May+June 2017 = 2986 , formula is ok

May+June 2016, selecting 2017 as year doesn't give me 3247 which is the value expected

Can you kindly check my dashboard ?

Thank you !

sunny_talwar — Wed, 06 Sep 2017 13:41:14 GMT

May be you forgot to add other set analysis

=Sum({<Year = {"$(=Max(Year)-1)"}, Area -= {'Area-not-available'}, Item_Category ={$(vNoInstruments)}>} ExtendedUSD)/1000