how to suppress null values in line chart

[jafari_ervin]

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.

[#2]

I have the same issue.

Have you found a solution?

[avinashelite]

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.

Hi

[#4]

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?

[avinashelite]

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.

[#6]

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

Thanks for responding, and apologies again.

[avinashelite]

Hi Ariel,

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