Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
laura_1
Partner - Contributor III
Partner - Contributor III

Aggregations on charts

Hi, 

I have a dataset with current date and YTD values, which are calculated at a daily interval:

Calendar DateCurrent DateYTD
01/05/20191010
02/05/20191525
03/05/20192348
04/05/20194694
05/05/201990184
..240424
31/05/201920444
01/06/201923467
02/06/201912479
03/06/201932511
04/06/201989600
05/06/201990690
..5001190
30/06/2019101200

 

I would like to create a chart showing YTD values, which would have month (rather than calendar date) as dimension - so for May 2019, the value should be 444 (value as of 31/05/2019), for June 2019 - 1200 (value as of 30/06/2019). However, because of different granularity, using month on X axis sums all calendar date values for that month - so e.g. for May 2019 I get 1229 which is incorrect. 

Is there a way to show YTD values on a monthly chart so that the values are not mis-summed? 

Many thanks,

Laura 

2 Replies
ChiragPradhan
Creator II
Creator II

Hi

If you have values for Current Date, why can't you use that field in your measure?

Regards

Chirag

laura_1
Partner - Contributor III
Partner - Contributor III
Author

Hi,

YTD aggregations are done in a database outside of QIikSense and I need to plot aggregated values on a chart rather than aggregate them in QS.