Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jafari_ervin
Creator III
Creator III

how to suppress null values in line chart

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.

Line Chart in excel.png

I Attached my excel file.

thanks a lot.

6 Replies
Not applicable

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.

Eg.png

Eg2.pngHi

Not applicable

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.

Not applicable

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