Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted
Not applicable

Re: Sums up to year to date

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
Highlighted
Not applicable

Re: Sums up to year to date

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

Highlighted
Not applicable

Re: Sums up to year to date

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

Highlighted
Not applicable

Re: Sums up to year to date

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