topic Re: How to not show empty fields? in QlikView

How to not show empty fields?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

See below graph. For the first few instances there is a 0 value. I would like the data to start at when there is a value so I don't have the diagonal red line (and the horizontal red line prior to that at the bottom of the graph). How can this be accomplished? I tried to find it in older topics but I could not find it.

There is an option to 'show as gaps' but that does not seem to do anything.

Hopefully I have given sufficient information, if not please ask !

Many thanks and best regards.

Re: How to not show empty fields?

neelamsaroha157 — Tue, 04 Sep 2018 17:48:51 GMT

Can you check if you have zero value suppressed on the presentation tab -

Re: How to not show empty fields?

Anonymous — Wed, 05 Sep 2018 07:38:34 GMT

I am using the Qlik cloud version, so I don't think I have this screen. Here are the options I can see:

Re: How to not show empty fields?

pooja_prabhu_n — Wed, 05 Sep 2018 08:14:11 GMT

Hi,

Check suppress when value is null in dimensions tab.

Thanks,

Pooja

Re: How to not show empty fields?

Anonymous — Wed, 05 Sep 2018 08:18:56 GMT

Hi Pooja,

It is, as far as I can see.

Re: How to not show empty fields?

Anil_Babu_Samineni — Wed, 05 Sep 2018 09:09:28 GMT

Do work around using expression to restrict the Null values?

Re: How to not show empty fields?

poojashribanger — Wed, 05 Sep 2018 09:11:29 GMT

you can use below expression as well

if(sum(expn)>0,sum(expn))

Re: How to not show empty fields?

Anonymous — Wed, 05 Sep 2018 11:25:05 GMT

Thanks a lot, that worked perfectly!

Thanks to all others as well for replying!