Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can sort your it in the reverse order and apply first option of limit.
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
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.
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
Thanks for the Help Kedar. I couldnt find the file. Could you share again ?
Hi Vinicius,
Please find attached the QVW file again..
- Kedar