topic Re: Displaying not null expressions in chart in QlikView

Displaying not null expressions in chart

Matt — Sat, 16 Nov 2024 04:08:23 GMT

Hi,

I have a simple pie chart with no dimensions, only expressions. Each of them is calculated, f.e. like this (just diff status)

COUNT({<[Status]={'Finished'}>} DISTINCT [Contract])

On few statuses I get zero values in the legend (count = 0)

How can I display only not null values in the legend?

Presentation tab -> suppress missing/zero-values is not working.

Thanks.

Regards,

anushree1 — Mon, 18 Mar 2019 10:09:53 GMT

Tick on Suppress when Value is Null in Dimensions Tab

Matt — Mon, 18 Mar 2019 10:16:55 GMT

Not available, since there are no dimenions to select

martinpohl — Mon, 18 Mar 2019 10:32:47 GMT

Use Expression condition to Show, see example

Regards

Matt — Mon, 18 Mar 2019 10:37:58 GMT

Thank you Martin.

I was putting >0 into ()...

Have a nice day!