topic Last year day comparison in QlikView

Last year day comparison

Wed, 28 Mar 2012 16:12:46 GMT

Hello,

I'm looking for a possibility to compare the current selected day values (e.g. sales )to the last years day (sales).

Because of some sepcial demands I have already a time table with the date_of_day and a second column last_year_day.

How can I build such a function in a metric expression ?

I guess set analysis, but I can't get it working.

Thank you !

pover — Wed, 28 Mar 2012 17:53:02 GMT

What type of filter does the user select? Calendar dates? Months? Days in numbers?

Karl

Wed, 28 Mar 2012 20:08:21 GMT

It's a calendar date and the last_year_date column is also type date.

pover — Wed, 28 Mar 2012 21:25:31 GMT

It's easier if you have separate year, month, day columns, but the following set analysis worked for me when the filter was a complete calendar date.

sum({$<Date={$(=chr(39) & concat(distinct makedate(year(Date)-1,month(Date),day(Date)),chr(39)&','&chr(39))&chr(39))}>} Sales)

The chr(39) are single quotes around the dates.

Karl

Wed, 28 Mar 2012 22:01:33 GMT

Thanks a lot !

But would it also be possible to use a different already created last year date in a separate table colmun last_year_day ?

pover — Wed, 28 Mar 2012 22:20:14 GMT

I had a feeling you might ask that. It should work if you adjust the expression to something like:

sum({$<Date={$(=chr(39) & concat(distinct last_year_day,chr(39)&','&chr(39))&chr(39))}>} Sales)

Thu, 10 May 2012 20:57:14 GMT

How can I compare the below dates?

1/5/2012 Thursday

1/6//2012 Thursday