Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Eduard23
Contributor III
Contributor III

Have Data that need to remove the zero

Hi All,

I have DATA that i need to remove the zero.

already try to convert zero to null but it is in measure

so i try to uncheck the Include zero values in Add-ons --> Data handling still not work.

i try to recreate the expression in Dimension but value is missing. hopefully some can help out to remove it either from 

nprinting or qliksens

Eduard23_0-1676512463271.png

 

Labels (3)
1 Reply
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi, 

For "Include zero values in Add-ons --> Data handling" to work all measures have to return true 0 or null. 

We dont know what is your data showing in all other measures - it can be that you have decimal points there which are shown with precision down to 2 decimal points but in reality hold value <> 0 hence your row still exists. 

Try by testing just with 1 measure and keep adding other measures to see which one is causing issue.

cheers

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.