topic max(Year)-1 returns somethins wrong date in QlikView

max(Year)-1 returns somethins wrong date

retko1985 — Fri, 11 Aug 2017 10:05:45 GMT

Hello,

I have a listbox with years (including 2018 from calendar database) and a variable vPriorYear, which has assigned =max(Year)-1.

Now I created a text box with this - =$(vPriorYear) or I also tried this - =vPriorYear .

Now I click through the years ans sometimes ( cant predict when) instead of the last year of the clicked year itdisplays 2017. So for example I click 2014 and text box displays 2017. It only reverse to 2017 year, not other different year.

I this behaviour familiar to someone? What can I do? Is here some other expression to refer to previous year of the selected that I can try?

Thank you.

Re: max(Year)-1 returns somethins wrong date

tresB — Fri, 11 Aug 2017 10:18:47 GMT

Could you post a sample representative qvw?

Re: max(Year)-1 returns somethins wrong date

chanin7893 — Fri, 11 Aug 2017 10:32:30 GMT

You can try this out in the expression column

Sum({<Year= {$(= max(Year-1))}>}[Field Name])

Re: max(Year)-1 returns somethins wrong date

retko1985 — Fri, 11 Aug 2017 11:09:12 GMT

I figured it out. There was a problem with alternate states. This works fine - =$(=max({<Year=$::Year>}Year-1))

Thank you.