Last 12 months sales data - Qlik Community

Report Inappropriate Content · ‎2016-03-22

Hi

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

Chanty4u · ‎2016-03-22

chk dis

Digvijay_Singh · ‎2016-03-22

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

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

Kushal_Chawda · ‎2016-03-22

try this expression

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

ecolomer · ‎2016-03-22

see this example

Kushal_Chawda · ‎2016-03-22

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

amit_saini · ‎2016-03-22

Hi,

Check

Thanks,

AS

Report Inappropriate Content · ‎2016-03-22

Hi

YearMonth is a time stamp and it is a num datattype

So please do the needful

Thiru

Report Inappropriate Content · ‎2016-03-22

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

So

what i have to use exactly?

Report Inappropriate Content · ‎2016-03-22

Hi