topic Re: Date comparison in QlikView

Date comparison

Anonymous — Mon, 10 Nov 2014 17:41:11 GMT

Hello !

I need to compare the max date of max year (Done), with the same day&month of year = 2011.

What i mean:

max date = 10/11/2014

sum(date={"<=$(=max(date))"}something) //Year of 2014

sum({<date={"<=$(=max(date))"}, year={2011}>}something)

This doesnt work.Because, the max date of second expression are different of month 11 and day 10.

I need to compare the historic in the same day. Sum of something in 10/11 in 2011 and 2014.

Somebody know how to do this?

Thanks!

Gysbert_Wassenaar — Mon, 10 Nov 2014 17:49:47 GMT

Try using the addyears function:

sum(date={"<=$(=max(date))"}something)

sum({<date={"<=$(=addyears(max(date),-3))"}>}something)

Anonymous — Mon, 10 Nov 2014 18:16:18 GMT

Thanks for the answer Gysbert!

I cant do this.

Because, my max year can be 2005, 2006, 2010, 2014, etc.

So i need to do this dynamic.

Is possible?

Thanks !

Gysbert_Wassenaar — Mon, 10 Nov 2014 18:23:12 GMT

Ok, maybe this then:

sum({<date={"<=$(=makedate(2011, month(max(date)), day(max(date)) ))"}>}something)

MarcoWedel — Mon, 10 Nov 2014 22:03:53 GMT

Hi,

one solution could be:

Sum({$<date={'$(=Max(date))'}>} something)/Sum({$<date={'$(=SetDateYear(Max(date),2011))'}>} something)

hope this helps

regards

Marco