Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Bar chart with Prev 12 months Rolling 6 month

Hi All,

I need to create bar chart.

Dimension -MonthYear

Bar chart should display dimension values only for last 12 Months. And each bar should display rolling 6 months of data.

for eg

I will have 12 bars for last 12 months (Sep-2014 to Aug 2015). Now the Sep-14 bar should display the values of rolling 6 months.

So Sep-2014 bar will display the values (Apr-2014 to Sep-2014). Like wise each bar should display rolling 6 months value.

Hope it is clear

10 Replies
Highlighted
sinanozdemir
Valued Contributor III

Re: Bar chart with Prev 12 months Rolling 6 month

Hi,

Before going into too deep, have you tried using "Accumulate" option in the expression tab? You can set it to 6 steps back.

Capture.PNG

Highlighted
Not applicable

Re: Bar chart with Prev 12 months Rolling 6 month

I had used this, but issue is when I select the particular month it will not display correct value

Highlighted
MVP
MVP

Re: Bar chart with Prev 12 months Rolling 6 month

This may help

Calculating rolling n-period totals, averages or other aggregations

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
MVP & Luminary
MVP & Luminary

Re: Bar chart with Prev 12 months Rolling 6 month

See attached example and this document: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand
Highlighted

Re: Bar chart with Prev 12 months Rolling 6 month

I had done that before with slightly different requirement.

Please see the attached.

This may be a startup.

Highlighted
Not applicable

Re: Bar chart with Prev 12 months Rolling 6 month

gwassenaar‌and Kush141087  both your solution works and it is what i need, but I want to achieve this on front end. Is it possible from front end?

Highlighted
Not applicable

Re: Bar chart with Prev 12 months Rolling 6 month

hi swuehl‌  can you please help me to do this from front end?

Highlighted
MVP
MVP

Re: Bar chart with Prev 12 months Rolling 6 month

Possibly, there are several threads here in the forum covering a front end solution, e.g.

Full accumulation: having dimensions reflecting selection but expression that don't

You can use Sum() instead of FirstSortedValue(), and maybe limit the dimensions shown either by setting in the chart properties or by using set analysis in the outer aggregation.

Highlighted
Not applicable

Re: Bar chart with Prev 12 months Rolling 6 month

Hi swuehl‌ thanks for your kind response. can you please give me a sample? It will be very helpful