Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below data:
YRMON | Amount1 | Amount2 |
201301 | 100 | |
201302 | 200 | 700 |
201303 | 300 | 800 |
201304 | 400 | |
201305 | 500 | 1000 |
201306 | 600 | 1100 |
201307 | 700 | 1200 |
201308 | 800 | |
201309 | 900 | 1300 |
201310 | 1000 | 1500 |
201311 | 1100 | 1600 |
201312 | 1200 | 1700 |
201401 | 1300 | 1800 |
201402 | 1400 | |
201403 | 1500 | 2000 |
201404 | 1600 | |
201405 | 1700 | 2200 |
201406 | 1800 | 2300 |
201407 | 1900 | |
201408 | 2000 | 2500 |
201409 | 2100 | 2600 |
OUTPUT:
201303 | 1100 |
201306 | 1700 |
201309 | 2200 |
201312 | 2900 |
201403 | 3100 |
201406 | 4100 |
201409 | 4700 |
I want to display in a chart only the Quarter End Year-Mon(Dimension) and the values of the Quarter end as shown above not the sum of the Quarters. Basically the above output in a chart. Please any one can help
Please do not double post, it makes the community harder for everyone to use. Consolidate your discussion under http://community.qlik.com/thread/137787 and close this thread.
Thanks,
Vlad
Didn't got answer in the earlier thread so had to put it in the different discussion forum. But wont do it next time.
Replied to your original post.
Hi,
one solution could be:
hope this helps
regards
Marco