topic Re: previous month Data in QlikView

previous month Data

Tue, 09 Feb 2016 06:41:14 GMT

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 — Tue, 09 Feb 2016 09:59:07 GMT

try dis,

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

sunny_talwar — Tue, 09 Feb 2016 10:03:16 GMT

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

Chanty4u — Tue, 09 Feb 2016 10:05:00 GMT

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

Anonymous — Tue, 09 Feb 2016 11:21:27 GMT

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 — Wed, 10 Feb 2016 03:35:42 GMT

Hi,

Try Above() in Qlikview Help file

=Above(Sum(Sales))

Regards,

Jagan.

HirisH_V7 — Wed, 10 Feb 2016 04:36:00 GMT

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,