This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i have small confusion in straight table.
how to convert null(-) value into 0 means
in my straight table my data has
my straight table showing above table.
i want show my straight table below how. please share me
i want show my straight second one .
On property objects, on presentation tab, uncheck Suppress zero-values, and Null Symbol and Missing Simbol may be 0 too.
Go to Presentation Tab and write 0 instead of '-' in Null symbol box.
easiest way would be to go to the presentation tab and at the bottom set the null symbol to 0, other options would be to use the isnull() function in the expression and covert the values to 0. same thing can be applied in the reload script.
Please find the settings where you can change the null symbol '-' to '0'
i had such Problem in the case with TableBox, i am not sure, but you can try to do tha same way in case with straight table.
my way of proceeding does look like:
first step: in Script-Area;
Set NullValue ='';
if(len(trim([yourField]))= 0, 'yourSign', [yourField]) as YourName
i hope that helps
If you want to accomplish this model wide, then in script add the following under the environmental variables (default vars)
Set NullValue = 0;
if you want to only do this per chart use the example Tamil gave you,
Alternatively, you could also do the below.
if(isNull(), 0, )