topic Re: max(date) and previous month same date sales in QlikView

max(date) and previous month same date sales

Thu, 25 Oct 2012 08:54:23 GMT

Hello,

In my pivot table,i want to display max(date) sales in one column and previous month same date sales in one column.I tried alot,but i am not getting.

how to write the expresion for this two in set analysis.

can anyone help me.

regards,

baru

Thu, 25 Oct 2012 09:04:19 GMT

Hi,

the expression would look like for your max(date) like this:

sum({<Date = {'$(=(max(Date)))'}>}sales)

and for the previous:

sum({<Date = {'$(=(MakeDate(year(max(Date)),Month(Max(Date))-1,day(max(Date)))))'}>}sales)

hope this helps there might be some () missing cause I haven't tested it 😉

regards,