topic Line chart accumulation in QlikView

Line chart accumulation

guyvermeiren — Wed, 26 May 2010 15:57:57 GMT

I have a line chart where I show 3 expressions and where the Period (Months 1 to 12) is the dimension.

However for the current Year I have no data available yet (Null) for the future months wich results in the "Accumulation" in a flat line which I don't want to show. (see picture)

Can I add a condition in a way that for the current year it only shows the line for the selected periods for the current year and the full lines for the other 2

Thanks,

Guy

Line chart accumulation

villafuerte — Wed, 26 May 2010 16:02:33 GMT

Hi Guy,

You can use a Set Analysis clause that only takes into account the past values and excludes the future ones.

Cheers

Line chart accumulation

boorgura — Wed, 26 May 2010 16:06:34 GMT

You can have a condition on that expression alone like -

if(date < today(), <expression>)

you can replace today() with the max date - if they are different.

Let me know if it works.

Line chart accumulation

guyvermeiren — Wed, 26 May 2010 16:08:37 GMT

Thanks already, but I don't have an idea how to proceed. Assume that "Period" is my dimension.

Line chart accumulation

guyvermeiren — Thu, 27 May 2010 08:47:03 GMT

Hi Rocky,

I used the next expression:

=if(Period<Num(Month(Today())), Sum( {$<[Fiscal Year]= {$(=max([Fiscal Year]))},Period= {'*'} >} [Gross Sales ] ))

The calculation is correct but it doesn't change a thing to the line chart. Has this something to do with the fact that I use "Full accumulation". When I add a condition Null() or zero to my if-statement the complete line results in zero.

Is there maybe a way to format the line style as blank / invisible or set the the line color to blank ?

Kind regards,

Guy