Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sums up to year to date

Hello guys,

I have this dashboard that displays data based on selected year/month/quarter.

The TOTAL (MONTH) text object displays sums of quantity based on the selected year/month/quarter.

The TOTAL (YTD) text object, however, will display year to date sums of all the quantities, in example :

If the year/month selected is 2012/JAN it will display sums of quantities up to JAN/2012. If the year/month selected is 2012/FEB it will display sums of 2012/JAN + 2012/FEB and so forth for the particular year.

While I was able to express the sums based on the month, can somebody give any opinions on how to calculate the year to date sum like I have described?

Attached is a sample file for your kind review.

Thank you for your kind attention guys

1 Solution

Accepted Solutions
Not applicable
Author

After searching around I found this seems to be what I am looking for

QlikView App: Simple Year To Date Example (Set Analysis)

Thank you for your kind attention guys. Really appreciate it

View solution in original post

3 Replies
Not applicable
Author

I would suggest to use island data as selection box field.

Not applicable
Author

After searching around I found this seems to be what I am looking for

QlikView App: Simple Year To Date Example (Set Analysis)

Thank you for your kind attention guys. Really appreciate it

Not applicable
Author

Wenkun Ma,

Thank you for your kind attention but I found out what I am looking for here

QlikView App: Simple Year To Date Example (Set Analysis)

Again thank you very much for your kind attention in answering my question.

Thank you