topic Year To Date Question in QlikView

Year To Date Question

Wed, 12 Mar 2014 09:10:29 GMT

I have a simple calculation like this (count(P2_skär) + count (P2_tryck)) and i present the answer in a guage chart.

It works fine when i choose a specific month or months but it's not the sum i want.

I would like the chart to show me the answer divided by the number of months this year (average for year to date).

Is this possible?

/Mats

Re: Year To Date Question

datanibbler — Wed, 12 Mar 2014 09:22:36 GMT

Hi Mats,

very few things are generally not possible.

To get a YTD status, you will have to

- use a set_analysis_expression with the {1} to ignore all user_selections

<=> but in that same expression, set a filter for the current year

=> Keep in mind that to use set_expression, you always need some aggregation_function. Avg() would seem a good idea to get the YTD_average (there are limitations, Henric Cronstroem has written about that, but I think that for the "rest of us", the traditional average is good enough)

HTH

Best regards,

DataNibbler

Re: Year To Date Question

stevedark — Wed, 12 Mar 2014 09:25:31 GMT

Hi Mats,

This example document shows how year to date can be calculated:

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

You could then simply divide by the max month variable to give you the average over months to date.

Hope that helps,

Steve