topic Re: Last month sales in QlikView

Last month sales

stephenedberkg — Mon, 24 Nov 2014 05:27:36 GMT

How to calculate the last month sales values?

Eg:

=Sum({$<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))}>}PrimarySales)

this above expression is currents month sales

Re: Last month sales

sujeetsingh — Mon, 24 Nov 2014 05:30:22 GMT

Comparing Current Month and Previous Month Sales

Current Month vs Last Month

Re: Last month sales

amit_saini — Mon, 24 Nov 2014 05:31:51 GMT

Stephan ,

See the attachment.

Thanks,

Re: Last month sales

jagan — Mon, 24 Nov 2014 05:36:01 GMT

Hi,

If you have date field try like this

=Sum({$<Year=,MonthID=, DateDimensionName={'>=$(=MonthStart(Max(DateDimensionName), -1))<=$(=MonthEnd(Max(DateDimensionName), -1))'}>} PrimarySales)

Hope this helps you.

Regards,

Jagan.

Re: Last month sales

stephenedberkg — Mon, 24 Nov 2014 06:18:43 GMT

Dears,

=Sum({$<Year={$(=Max(Year))},MonthID={$(=Max(MonthID-1))}>}Sales)

this above expression is correct or wrong for the last month sales

Re: Last month sales

jagan — Mon, 24 Nov 2014 06:33:29 GMT

Hi,

Let us assume if you select 2014 and Month as january then your expression will return

Null value because 1(Jan) - 1 gives you zero.

Hope this helps you.

Regards,

Jagan.

Re: Last month sales

stephenedberkg — Mon, 24 Nov 2014 07:09:42 GMT

Re: Last month sales

Dear jagan

This kind of situation how to take the 2013 Dec values?

Regards,

Stephen Edberk

Re: Last month sales

jagan — Mon, 24 Nov 2014 07:21:22 GMT

Hi,

If you don't have date field then arrive the date field in script like below

LOAD

MakeDate(Year, MonthID) AS DateDimensionName

FROM DataSource;

Now use below expression for getting the last month sales

=Sum({$<Year=,MonthID=, DateDimensionName={'>=$(=MonthStart(Max(DateDimensionName), -1))<=$(=MonthEnd(Max(DateDimensionName), -1))'}>} PrimarySales)

Hope this helps you.

Regards,

Jagan.