Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum one dimension into a monthly dimension

I am having trouble trying to present monthly information on a bar chart. I am currently collecting a data input that is captured on a daily basis (dimension 1) and trying to present that sum on a monthly basis (dimension 2). I currently have my dimensions set as 'Month' and my expressions follow this format; COUNT({$}{<Med1={'3','1'}>} Eyes_Today_Date_Saved). When I change my dimensions to 'Eyes_Today_Date_Saved' it shows all dates on the chart. What I am trying to do is have it sum 'Eyes_Today_Date_Saved' for each 'Month' and have that information presented on the chart.

THANKS,

Kyle

4 Replies
sunny_talwar

Would you be able to share a sample?

Not applicable
Author

I am not sure how to so this is the only information I can show you.

sunny_talwar

Just throw in few lines of data which is representative of your actual data and let us know the expected result.

Not applicable
Author

Dimension: 'Months' = May-2015, June-2015, July-2015

                    'Eyes_Today_Date_Saved' = 5/15/2015, 5/19/2015, 5/25/2015, 6/5/2015, 6/11/2015, 6/18/2015, 6/26/2015, 7/3/2015, 7/6/2015