Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

klewandowski
New Contributor III

Limit dimension in aggregated chart

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: Limit dimension in aggregated chart

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

19 Replies

Re: Limit dimension in aggregated chart

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

Capture.PNG

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)

MVP
MVP

Re: Limit dimension in aggregated chart

Sunny, looks quite fine just opening your QVF:

a1da3fe98ae442f38450849783923bf3.png

I think I am using QS 2.1.1 still...

Re: Limit dimension in aggregated chart

Strange, I am using this:

Capture.PNG

klewandowski
New Contributor III

Re: Limit dimension in aggregated chart

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

reddys310
Honored Contributor II

Re: Limit dimension in aggregated chart

Hi Sunny and Kamil,

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

Capture.PNG

Thanks,

Sangram.

Re: Limit dimension in aggregated chart

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.

MVP
MVP

Re: Limit dimension in aggregated chart

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

reddys310
Honored Contributor II

Re: Limit dimension in aggregated chart

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.

Re: Limit dimension in aggregated chart

This one looks good

Capture.PNG

Community Browser