Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

CountTime.JPG.jpg

Attached is the QlikView file for reference.

Thank you!

Irene

3 Replies
fdelacal
Specialist
Specialist

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

If you put nos accumulative is llok fine.

Not applicable
Author

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

fdelacal
Specialist
Specialist

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