topic Hiding Cumulative Graph Portion when Value is Zero in QlikView

Hiding Cumulative Graph Portion when Value is Zero

Tue, 10 Dec 2013 15:20:43 GMT

Hello,

Is there a way to hide the flat, circled portion of the yellow cumulative graph below ("Mary Cumulative Count"), since the values for Days 9 and 10 are Zero for Mary? I would like the graph and table to look exactly the same, but for the yellow cumulative line to stop at Day 8.

Attached is the QlikView file for reference.

Thank you!

Irene

Re: Hiding Cumulative Graph Portion when Value is Zero

fdelacal — Tue, 10 Dec 2013 15:34:57 GMT

In 3er and 4rt expression you check accumulative., is for that the line grow.

If you put nos accumulative is llok fine.

Re: Hiding Cumulative Graph Portion when Value is Zero

Tue, 10 Dec 2013 15:43:06 GMT

Hi Facundo - I want the yellow line to display cumulative, so I need that checked. I just want the line to display up until month 9 (do not display for month 9 and 10 ONLY).

Thanks,

Irene

Re: Hiding Cumulative Graph Portion when Value is Zero

fdelacal — Tue, 10 Dec 2013 15:58:32 GMT

In expression you can put this. but never dissapear beacuse you has in the dimension de Day.

Expression 3 =

sum( {$< Day = {'1','2','3','4','5','6','7','8'}>} [Keith Count] )

Expression 4 =

sum( {$< Day = {'1','2','3','4','5','6','7','8'}>} [Mary Count])

Regards