topic Re: how to show last month data with current month selection in QlikView

how to show last month data with current month selection

Wed, 06 Mar 2013 10:23:20 GMT

how to show last month data with current month selection ????

sushil353 — Wed, 06 Mar 2013 10:25:49 GMT

=sum({<month={">=$(Max(Month)-1) <=$(Max(Month))"}>}value)

somenathroy — Wed, 06 Mar 2013 10:44:16 GMT

{<Date={'$(=Max(Date))'}>}

[where Date is Calendar Date of the selected month]

or you may use

{<TDate={'$(=Max(TDate))'}>}

[where TDate is Transaction date of the selected month]

Regards,

Som

jagan — Wed, 06 Mar 2013 11:01:10 GMT

Hi Vignesh,

If you have a date field in your table then use this

=Sum({<MonthField=, DateField={'>=$(=MonthStart(Max(DateField), -1))<=$(=MonthEnd(Max(DateField), -1))'}>} Sales)

Hope this helps you.

Regards,

Jagan.

Wed, 06 Mar 2013 11:08:27 GMT

use the addmonths function

AddMonths(START_DATE,-1)

use this in ur expr tab

it works

neha_shirsath — Wed, 06 Mar 2013 12:02:02 GMT

Hi Vighnesh,

Try this Expression-

=sum({<Year={$(=max(Year))},Month={$(=month(addmonths((max(Date)),-1)))}>}Sales)

Regards,

Neha