Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
aashok
Contributor III
Contributor III

Hide Null/Zero Values in Qlik sense chart.

Hi , I understand that this question has been asked several times in the forum and many answers were given.

However it seems like none of them are working for me. Could anyone please help me in telling how not to show the zero  data for the chart? 

for the chart below, it should be  not showing the yellow highlighted part, only till the value which is not zero.

aashok_0-1649053444948.png

I have tried to suppress the null values box and also update the measures with the formula 

if (expression>0,expression). both cases do not work. 

Labels (2)
3 Replies
EliGohar
Partner - Creator III
Partner - Creator III

If it's zero then uncheck Include zero values:

EliGohar_0-1649054818882.png

Did you try it?

aashok
Contributor III
Contributor III
Author

Hi @EliGohar ,

thanks for the reply.

I have already tried it.

its null value.

aashok_0-1649055050733.png

but still does not work.

aashok
Contributor III
Contributor III
Author

Hi, 

I have found a temp solution to my problem.

I changed the  missing values to Show as Gaps  from show as zeros  together with unchecking the null values and zero values boxes and it seems to work for now. Could any experts here let me know if this is an acceptable solution?

aashok_0-1649238166628.png