Discussion board where members can get started with Qlik Sense.
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.
But the problem is CY(Orange Line) Sales we have data till September so, I want to hide CY line after September.
Go to Solution.
goto data handling tab
un tick suppress null value. or
Thanks, Chanty for your reply,
you second condition work
I used below expression
Give condition like expression>0
If(Sum(whatever) > 0, Sum(Whatever))
did it for me...