Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ahmar811
Contributor III

Hide Zero value line chart

Hi

Experts,

Please find below screenshot where my chart shows cumulative Sales CY (Orange Line), PY(Black Line), Budget (Light Orange Line) using rangesum and above function in Qliksense.

Capture.PNG

But the problem is CY(Orange Line) Sales we have data till September so, I want to hide CY line after September.

Regards

Ahmar

1 Solution

Accepted Solutions
sureshqv
Esteemed Contributor III

Re: Hide Zero value line chart

goto data handling tab

un tick suppress null value.   or

conditional :

your expression>0

4 Replies
sureshqv
Esteemed Contributor III

Re: Hide Zero value line chart

goto data handling tab

un tick suppress null value.   or

conditional :

your expression>0

ahmar811
Contributor III

Re: Hide Zero value line chart

Thanks, Chanty for your reply,

you second condition work

I used below expression

if(expression>0,expression)

kashaboinaraj
Contributor

Re: Hide Zero value line chart

Give condition like expression>0

paulgeudens
New Contributor

Re: Hide Zero value line chart

Thanks!



If(Sum(whatever) > 0, Sum(Whatever))

did it for me...

Community Browser