topic Re: set analysis year-1 in QlikView

set analysis year-1

zied_ahmed1 — Fri, 02 Feb 2018 09:54:54 GMT

Hello,

I would like to display value of the year-1 for a year selected i use this but this gives me the value of the year selected :

=sum({$<Year= {$(=Year(Today())-1)}>} ACCOUNTINGCURRENCYAMOUNT)

Thanks

tresB — Fri, 02 Feb 2018 09:59:27 GMT

Try like:

=sum({$<Year= {$(=Max(Year)-1)}>} ACCOUNTINGCURRENCYAMOUNT)

Chanty4u — Fri, 02 Feb 2018 10:00:47 GMT

check here max possible ways displayed

OmarBenSalem — Fri, 02 Feb 2018 10:02:22 GMT

Works fine for me !

How are you selecting ur Year? is it the same Year field u're using in this expression? Or u have another Year field (maybe calculated) ?

zied_ahmed1 — Fri, 02 Feb 2018 10:24:51 GMT

I changed the name of the field Year in the master calendar but same thing i have the same values for year and year-1

zied_ahmed1 — Fri, 02 Feb 2018 10:25:16 GMT

Same thing it doesn't work...

OmarBenSalem — Fri, 02 Feb 2018 10:30:23 GMT

Hold on a second :

in your expression, you're using one Year field; and then you're filtering by another Year field (the one from the master calendar) ?

Is that so?

tresB — Fri, 02 Feb 2018 10:33:05 GMT

There could be many feasible reasons why it would not work. Try to share your sample qvw.

zied_ahmed1 — Fri, 02 Feb 2018 10:35:43 GMT

Yes I changed the name of field Year in Master calendar to Annee and this is the filter :

And this is the set analysis :