Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

max(date) and previous month same date sales

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

1 Reply
Not applicable

Re: max(date) and previous month same date sales

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,

MT

Community Browser