Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Only to Display Quarter End Values

I have the below data:

YRMONAmount1Amount2
201301100
201302200700
201303300800
201304400
2013055001000
2013066001100
2013077001200
201308800
2013099001300
20131010001500
20131111001600
20131212001700
20140113001800
2014021400
20140315002000
2014041600
20140517002200
20140618002300
2014071900
20140820002500
20140921002600


OUTPUT:

2013031100
2013061700
2013092200
2013122900
2014033100
2014064100
2014094700

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

1 Solution

Accepted Solutions
MarcoWedel

Hi,

one solution could be:

QlikCommunity_Thread_137789_Pic1.JPG.jpg

QlikCommunity_Thread_137789_Pic2.JPG.jpg

hope this helps

regards

Marco

View solution in original post

4 Replies
vgutkovsky
Master II
Master II

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

Anonymous
Not applicable
Author

Didn't got answer in the earlier thread so had to put it in the different discussion forum. But wont do it next time.

vgutkovsky
Master II
Master II

Replied to your original post.

MarcoWedel

Hi,

one solution could be:

QlikCommunity_Thread_137789_Pic1.JPG.jpg

QlikCommunity_Thread_137789_Pic2.JPG.jpg

hope this helps

regards

Marco