topic Year number in QlikView

Year number

Fri, 04 Apr 2014 15:22:09 GMT

I have a problem to compare the current year with the previous year.

sum({$<Year={$(=Max(Year-1))}>}if(Kontonummer >= 41250000 and Kontonummer < 49300000,SummeSoll-SummeHaben))*-1

sum({$<Year={$(=Max(Year))}>}if(Kontonummer >= 41250000 and Kontonummer < 49300000,SummeSoll-SummeHaben))*-1

the problem is, the current year is 2014 and the previous year 41639.

Why is in the previous year the number????

I formatted the field WJ in the script like this

WJ,

DATE(Date#(WJ,'YYYYMMDD'),'DD.MM.YYYY') AS DATE,

DATE(Date#(WJ,'YYYYMMDD'),'YYYY') AS Year,

There are only two values in WJ, (20130101 and 20140101)

Nicole-Smith — Fri, 04 Apr 2014 15:30:02 GMT

Instead of:

DATE(Date#(WJ,'YYYYMMDD'),'YYYY') AS Year

Use the Year() function:

Year(Date#(WJ,'YYYYMMDD')) AS Year,

MK_QSL — Fri, 04 Apr 2014 15:30:58 GMT

sum({$<Year={'$(=NUM(Max(Year-1)))'}>}if(Kontonummer >= 41250000 and Kontonummer < 49300000,SummeSoll-SummeHaben))*-1

sum({$<Year={'$(=Max(Year))'}>}if(Kontonummer >= 41250000 and Kontonummer < 49300000,SummeSoll-SummeHaben))*-1

MarcoARaymundo — Fri, 04 Apr 2014 15:40:04 GMT

Hi!

Andreas Max(Year-1) it is not correct, the corret is: (Max(Year)-1)

Or try this:

Current year => Year(Today())

Previous year => AddMonths(Year(Today()), -12)

Fri, 04 Apr 2014 20:55:52 GMT

Thank u

good to work with profis....