topic Re: Last 12 months sales data in QlikView

Last 12 months sales data

Wed, 25 Nov 2020 16:16:04 GMT

Want to display last 12 months sales data.

My columns are

yearmonth which is a number

Amount which a sales amount filed

So can you please guide me how to get the last 12 months data?

Please do the needful

Thir

Re: Last 12 months sales data

Chanty4u — Tue, 22 Mar 2016 08:31:42 GMT

chk dis

Last 12 Months Sales

Set Analysis for certain Point in Time

Re: Last 12 months sales data

Digvijay_Singh — Tue, 22 Mar 2016 08:34:20 GMT

If yearmonth is a seq no then you may use expression something like -

Sum({$<yearmonth = {“>=$(=Max(yearmonth ) – 11)<=$(=Max(yearmonth ))”}>} Amount )

Re: Last 12 months sales data

Kushal_Chawda — Tue, 22 Mar 2016 08:35:20 GMT

try this expression

rangesum(above(Sum(Salesamount),0,12))

Re: Last 12 months sales data

ecolomer — Tue, 22 Mar 2016 08:35:43 GMT

see this example

Re: Last 12 months sales data

Kushal_Chawda — Tue, 22 Mar 2016 08:56:18 GMT

or see the below link using which you can do the same from script itself

Rolling N months

Re: Last 12 months sales data

amit_saini — Tue, 22 Mar 2016 09:00:01 GMT

Hi,

Check

Thanks,

Re: Last 12 months sales data

Tue, 22 Mar 2016 09:01:10 GMT

YearMonth is a time stamp and it is a num datattype

So please do the needful

Thiru

Re: Last 12 months sales data

Tue, 22 Mar 2016 09:05:34 GMT

Hi AS

It's not working

=Sum({<YearMonth={‘>=$(=MonthStart(Today(), -11))<=$(=Today())’}>}Amount)

showing error

and

=sum({<YearMonth={">$(=monthstart(max(YearMonth),-12))<$(=monthstart(max(YearMonth)))"}>}Amount)

It is showing 0

what i have to use exactly?

Re: Last 12 months sales data

Tue, 22 Mar 2016 09:30:31 GMT

It's not working

=Sum({<YearMonth={‘>=$(=MonthStart(Today(), -11))<=$(=Today())’}>}Amount)

showing error

and

=sum({<YearMonth={">$(=monthstart(max(YearMonth),-12))<$(=monthstart(max(YearMonth)))"}>}Amount)

It is showing 0

what i have to use exactly?

Re: Last 12 months sales data

ecolomer — Tue, 22 Mar 2016 11:50:00 GMT

Sum({<YearMonth ={">=$(=Date(addmonths(Max(YearMonth), -12), 'MMM-YY')) <=$(=Date(addmonths(Max(YearMonth),-1), 'MMM-YY'))"} >} Amount)

Re: Last 12 months sales data

Wed, 23 Mar 2016 07:26:41 GMT

I have applied the same but it is showing 0 and not reflecting based on my change in the months like 12 or 6 or 3 etc.

It is showing 0 always

Any changes i need to do hear?

Please do the needful

Thanks

Thiru

Re: Last 12 months sales data

ecolomer — Wed, 23 Mar 2016 19:07:53 GMT

See this:

Calculating rolling n-period totals, averages or other aggregations