Hide Zero-Value Lines in Qlik Chart

[aruneshgupta]

Hi All,

I have 4 expressions, but based on selection, only 1 expression will display a line. My requirement is to show only the line that has values and hide the other 3 lines that show 0 values. I have already unchecked 'Include zero values,' but it’s not working as expected.

Please suggest.

Thank you!

Arunesh

[Rohan · Accepted solution]

Hi @aruneshgupta ,

Instead use the hide & show Functionality, in the measures pannel & use a condition like :

Measure A : Count({<Field={"A"}>} Field)>1

MeasureB :  Count({<Field={"B"}>} Field)>1

MeasureC :  Count({<Field={"C"}>} Field)>1

MeasureD :  Count({<Field={"D"}>} Field)>1

This way you can hide the remaining 3 lines, & keep At least 1 value selected in the Field that you are going to use for the filter. Let me know if it works for you.

Regards,

Rohan.