Discussion Board for collaboration related to QlikView App Development.
I am loading data off an excel file and find that whenever the value is a zero, then it does not show in my straight table.
I checked the properties to show all values, even nulls!
I can however see the zero values in the preview table in the table structure, just not on the front end for some reason.
As an example in the load script, if I say num(if([Value] = 0, 0, [Value])) as Value, nothing is returned.
If I say num(if([Value] = 0, 111, [Value])) as Value, then 111 is returned.
Not certain as to what I am missing here.
Go to Solution.
Are you using this in chart or script?
If you are using this in chart then make sure you have seen below property.
Chart Properties -> Presentation -> Suppress Zero Value.
Make sure that this property is unchecked.
View solution in original post
Thank you for your assistance, it worked!
Yes, it's in my straight table.
I have never noticed this option in Presentation - I was checking under Properties.