Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor

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.

Not applicable

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

fdelacal
Valued Contributor

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

Community Browser