3 Replies Latest reply: Dec 10, 2013 10:58 AM by facundo de la cal

# Hiding Cumulative Graph Portion when Value is Zero

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

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

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

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