No Last records in Dimension Limit

[vinicius_siquei]

Hi, I have a regular chart that present the sum of values by Month/Year.

I have to limit this chart to present only the last 6 months, however QV doesn't have the last option on dimension limit. What is the best approach to solve this problem ? Thanks

[tresesco]

You can sort your it in the reverse order and apply first option of limit.

[#3]

Hi,

If your month in text then select z->a in text or if your month in numeric then select descending order in the sort tab

and use the dimension limit for no of records you want

[vinicius_siquei]

In this case I'll have the data presented in reverse order.

There's any way to preserve original order ?

It would avoid changes in expression using accumulation.

[kedar_dandekar]

Hi Vinicius,

One way would be using Set-Analysis on all your expression to filter data only for the last X months.

Check if the attached QVW approach works for you..

- KD

[vinicius_siquei]

Thanks for the Help Kedar. I couldnt find the file. Could you share again ?

[kedar_dandekar · Accepted solution]

Hi Vinicius,

Please find attached the QVW file again..

- Kedar