previous month Data

[#1]

Dear All,

i want to display previous month data on current month selection consider the below scenario.

Here for Jan Month TS is 10 so output will be like for Feb Month it must show the value 10 and so on . field (Date) must be in dimension

[Chanty4u]

try dis,

=sum({<Date={">=$(=Date(monthstart(addmonths(max(Date),-1))))<=$(=Date(monthend(addmonths(max(Date),-1))))"}, Year=,Month=, Date=>}TS

[sunny_talwar]

Try exploring the Above() function or provide a sample app to help better

[Chanty4u]

=If(Sum(TS) > 0, Above(Sum({<Date, MonthYear>}TS)))

[Anonymous]

Day:

LOAD * INLINE [

    Day, Sales

    01/01/2015, 10

    01/02/2015, 20

    01/03/2015, 30

    01/04/2015, 40

    01/05/2015, 50

];

Sum({<Day ={'$(vmonth)'}>}Sales)

vmonth = Date(MonthStart(MonthStart(Day)-1))

[jagan]

Hi,

Try Above() in Qlikview Help file

=Above(Sum(Sales))

Regards,

Jagan.

[HirisH_V7]

Hi,

May be like this,

When you select a Month Report will show previous month data,

Sum({<Month={"$(=Month(MonthStart(Max(Date))-1))"}>}Sales)

PFA,

Hope this Helps,