Limit dimension in aggregated chart

[Anonymous]

Hi.

I have such a strange problem:

I have aggregated chart (rangesum above fo months from the begining of data till now) and it is ok. But I need to see only last 12 months of it.

I cannot limit dimension for top 12 (months) becouse I need calculate all months.

Screens below. I hope anybody can help.

And if I limit this chart with dimension settings or set expression I will only get calculated last 12 months which is wrong.

[sunny_talwar]

I am able to get the line chart for the part needed, but not able to remove the dates from axis:

May be reddys310‌ can help

UPDATE: Expression used:

RangeSum(Above(Sum({<[Year-Month]>}Value), 0, RowNo())) *

Avg({<[Year-Month] = {"$(='>=' & Date(AddMonths(Max([Year-Month]), -12), 'YYYY-MM') & '<=' & Date(AddMonths(Max([Year-Month]), 0), 'YYYY-MM'))"}>}1)

[swuehl]

Sunny, looks quite fine just opening your QVF:

I think I am using QS 2.1.1 still...

[sunny_talwar]

Strange, I am using this:

[Anonymous]

Perhaps, I am using Sense 2.2 and I see as Sunny

[reddy-s]

Hi Sunny and Kamil,

You can use this to remove the dates from the axis:

Thanks,

Sangram.

[sunny_talwar]

I knew it. I knew you won't disappoint me with a Qlik Sense question sangram‌. You are my go to man when it comes to Qlik Sense . Thank you for your response.

[swuehl · Accepted solution]

Sunny, can you open and have a look at this sample?

As an alternative approach, the OP could use an AsOf table:

The As-Of Table

[reddy-s]

Hi Sunny,

Thank you so much for your kind words, but frankly speaking I am getting to learn a lot from your contributions in the community and good work. I should be the one thanking you.

[sunny_talwar]

This one looks good