How to not show empty fields?

[Anonymous]

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.

[neelamsaroha157]

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

[Anonymous]

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

[pooja_prabhu_n]

Hi,

Check suppress when value is null in dimensions tab.

Thanks,

Pooja

[Anonymous]

Hi Pooja,

It is, as far as I can see.

[Anil_Babu_Samineni]

Do work around using expression to restrict the Null values?

[poojashribanger · Accepted solution]

you can use below expression as well

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

[Anonymous]

Thanks a lot, that worked perfectly!

Thanks to all others as well for replying!