topic Re: Rolling months bar chart in QlikView

Rolling months bar chart

Wed, 12 Nov 2014 13:03:55 GMT

I want to know how to make a bar chart display the past 12 months (including the months selected). How can that be done?

Re: Rolling months bar chart

senpradip007 — Wed, 12 Nov 2014 13:07:28 GMT

Try this expression Sum({<Date={">=$(=AddMonths(Max(Date),-12)) <=$(=Max(Date)) "}>} Value) with Month as dimension.

Re: Rolling months bar chart

Anonymous — Wed, 12 Nov 2014 13:07:59 GMT

Hi Amit,

You can achieve the Rolling months chart by using addmonths function. Define a variable which holds the current day. And equal another variable for last 12 months. By calling you date field to match this variable you can achieve the same.

-Jay

Re: Rolling months bar chart

Wed, 12 Nov 2014 13:15:55 GMT

What is Date in this expression?

Re: Rolling months bar chart

senpradip007 — Thu, 13 Nov 2014 04:56:05 GMT

Date may be calendar date or financial date, as you've created the calendar in your application.

Re: Rolling months bar chart

amit_saini — Thu, 13 Nov 2014 04:59:31 GMT

Amit,

See the attachment.

Thanks,

Re: Rolling months bar chart

Thu, 13 Nov 2014 05:03:28 GMT

try like this

sum({<monthid={">=$(=max(monthid)-11) <=$(=max(monthid))"},year=,quarter=,month=>}sales}

sum(aggr(rangesum(above(totalsum({<month=>}amount),0,12)),month))

Re: Rolling months bar chart

sujeetsingh — Thu, 13 Nov 2014 05:37:54 GMT

Use accumulation option provided in Charts

Re: Rolling months bar chart

sujeetsingh — Thu, 13 Nov 2014 05:38:55 GMT

Follow these threads please

Need an Expression for Full Accumulation/Cumulative in a Pivot table

Full Accumulation in Straight Table, more than one Dimension

Re: Rolling months bar chart

ashfaq_haseeb — Thu, 13 Nov 2014 06:19:28 GMT

Hi,

Try this

Sum({<DATE={">=$(=MonthStart(Max(DATE),-12)) <=$(=MonthEnd(Max(DATE)))"}>} SALES)

Regards

ASHFAQ

Re: Rolling months bar chart

Thu, 13 Nov 2014 12:08:29 GMT

Thanks guys. All of your answers helped.