topic YearToDate Chart in QlikView

YearToDate Chart

Tue, 19 Apr 2011 14:40:23 GMT

Hello, I have a problem to make a chart with a ytd expression against a period dimension when I use the product dimension it works right.

I made an example in QV, can anyone help me out here?

Thnx in advance!

YearToDate Chart

pover — Tue, 19 Apr 2011 18:59:33 GMT

Hello,

In a table expression, you can't refer to values outside each row without using inter-row functions. Change your expression to the following and it will work:

rangeavg(above(
IF(InYearToDate(KEY_DATE,'01-'&PERIOD&'-'&PIT_YEAR,0), AMOUNT)
,0,11)
)

Regards.

YearToDate Chart

Wed, 20 Apr 2011 09:12:23 GMT

That's a solution, the formula should be;

rangeavg(above(
IF(InYearToDate(KEY_DATE,'01-'&PERIOD&'-'&PIT_YEAR,0), AMOUNT)
,0,12)
)

Another solution is to make a new time table called 'CHARTTIMETABLE' and put the PERIOD field of this table in the dimension, see attached file.

YearToDate Chart

pover — Wed, 20 Apr 2011 16:43:02 GMT

Yeap, using a date island table is also a solution. Just be aware that that solution does not scale well when you have a large volumn of data.

Regards.