Hide Zero-Value Lines in Qlik Chart

aruneshgupta — Fri, 15 Nov 2024 20:50:30 GMT

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

Re: Hide Zero-Value Lines in Qlik Chart

Rohan — Thu, 07 Nov 2024 06:22:53 GMT

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.

topic Re: Hide Zero-Value Lines in Qlik Chart in App Development

Hide Zero-Value Lines in Qlik Chart

Re: Hide Zero-Value Lines in Qlik Chart