topic Re: Display Last 13 months sales in QlikView

Display Last 13 months sales

PRS — Sat, 03 Sep 2016 17:40:32 GMT

Hi Techies,

I want to display last 13 months sales on bar chart based on the month that i selected.

Can i get any suggestions regarding this?

Help is appreciated

Thanks,

Raja

Re: Display Last 13 months sales

stabben23 — Sat, 03 Sep 2016 19:16:02 GMT

Hi,

maybe something like Sum({<Year=, Month=, MonthYear=, Date= {">=$(=(AddMonths(MonthYear,-13))) <=$(=(AddMonths(MonthYear,0)))"}>} Sales) in your expression.

Re: Display Last 13 months sales

effinty2112 — Sat, 03 Sep 2016 20:16:39 GMT

Hi Raja,

Maybe:

=Sum({$<Month=, Year=, Date = {">=$(=Monthstart(AddMonths(Max(Date),-13)))<=$(=max(Date))"}>}Amount)

Cheers

Andrew

Re: Display Last 13 months sales

saimahasan — Sun, 04 Sep 2016 15:11:18 GMT

Try this,

It worked.

=Sum({$<order_date=, order_date_day=, order_date_month=, order_date_year=,

order_date_yearmonth = {">=$(=(AddMonths(Max(order_date_yearmonth),-12)))<=$(=(Max(order_date_yearmonth)))"}>}[Total Amount])

Re: Display Last 13 months sales

saimahasan — Mon, 05 Sep 2016 13:39:26 GMT

Hi Raja,

If you have got the correct answer then please mark the answer as "Correct answer" and close this discussion.