topic Re: how to suppress null values in line chart in QlikView

how to suppress null values in line chart

jafari_ervin — Wed, 26 Dec 2012 12:15:17 GMT

Hi I have a problem in qlikview line chart, I have ke excel like below and I want to show my line chart like below please help me.

I Attached my excel file.

thanks a lot.

Re: how to suppress null values in line chart

Thu, 28 Aug 2014 04:57:12 GMT

I have the same issue.

Have you found a solution?

Re: how to suppress null values in line chart

avinashelite — Thu, 28 Aug 2014 05:03:06 GMT

Hi Jafari,

In the Dimension tab check the suppress null option in Dimension tab and presentation tab in properties. If still it occurs use calculated dimension like if(len(fieldname)>0,fieldname) and tick suppress null.

Re: how to suppress null values in line chart

Thu, 28 Aug 2014 05:10:44 GMT

This isn't working for me. I think the reason is that I am not trying to suppress dimensions with value NULL, rather I am trying to suppress expression values with value NULL.

Am I missing something?

Re: how to suppress null values in line chart

avinashelite — Thu, 28 Aug 2014 05:38:33 GMT

Hi Ariel,

Yes you rite, in the above case Null values are in Dimension so your suppress null in expression will not work.

Can you please post your app.

Re: how to suppress null values in line chart

Thu, 28 Aug 2014 05:44:53 GMT

Apologies, this turned out to be a data issue on my end (not related to Qlikview settings).

Thanks for responding, and apologies again.

Re: how to suppress null values in line chart

avinashelite — Thu, 28 Aug 2014 05:52:18 GMT

Hi Ariel,

No problem and no need of apologies too everyday is a learning for all .