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

need expression for max(date) and previous month same date sales

Mon, 29 Oct 2012 12:35:41 GMT

Hi,

Can anyone share me the max(date) sales and previous month same date sales.

when i select the date in list box,one column should show that date sales and one column should show previous month same date sales.

regards,

baru

Mon, 29 Oct 2012 12:45:05 GMT

Hi, Please use the set expresiion for the previous month same day sales:

Sum({DATE_FIELD={$(=(DATE_FIELD-30))}}Sales)

If you have any problems, please provide the qvw with some data.

jagan — Mon, 29 Oct 2012 13:17:16 GMT

Hi,

Try this expressions

For Current month

=Sum({<DateFieldName={"=$(=Max(DateFieldName))"}>} Sales)

For Previous month:

=Sum({<DateFieldName={"$(=Addmonths(Max(DateFieldName), -1))"}>}Sales)

Hope this helps you.

Regards,

Jagan.