Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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

View solution in original post

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