topic Re: get values for the last year in QlikView

get values for the last year

Anonymous — Fri, 16 Oct 2015 15:36:43 GMT

I have a variables in format YYYYMMDD

I have the following expression

sum({$<Date ={">=$(vFromDate) <=$(=if((right($(vToDate),2) ='31' and right(left($(vToDate),6),2) ='12' ),left(AddYears(vToDate,1),4)&'01'&'01',if(right($(vToDate),2) ='31', left(vToDate,4)&right(left(AddMonths(vToDate,1),7),2)&'01', left($(vToDate),6)&(right($(vToDate),2) ))))"}>}[Prix de vente TTC])

How can I get values for the same period but for the last year for the same expression ?

Re: get values for the last year

sunny_talwar — Fri, 16 Oct 2015 15:38:14 GMT

Are you using this in a chart with Date as a dimension or is this a text box expression?

Re: get values for the last year

Anonymous — Fri, 16 Oct 2015 15:42:00 GMT

in a chart

Re: get values for the last year

sunny_talwar — Fri, 16 Oct 2015 15:44:29 GMT

If date is your dimension then you will need to use the above() or below() function based on your sorting to get this to work. To find the exact expression, it would be more useful if you can provide a sample to work with.

Best,

Sunny