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.
Is it possible to view 0-values and to eliminate null values?
When I mark "Show all values" I also see the null values. When I mark "Suppress zero values" zero and null values are suppressed.
use supress null values only then i believe u can see 0 values
When I use "Suppress null values" zero values are suppressed also.
I don't have QlikView on the machine I have access now, but I think there is a check box "supress zero values", which is the one to uncheck.
Plz find the attachements. It ll help u
thank you for your reply and your example qvw file!
Unfortunately I suppose it´s not the solution I´m looking for:
If I add "Customer-ID=4" in your example without any values I don´t know how to display "Customer-ID=3" having a zero value and to suppress "Customer-ID=4" having a null value.
Check this attachements.
Check this attachment.
My customer ID 5 and 4 Does not have value i.e null. so it`ll not show that in pivot table but customer id 3 has 0 value. it is showing in pivot table.
I was looking for that. Thanks for your reply!
As I use a group as dimension and because "if(isnull(values)<>-1,group_xy)" as dimension is not working properly I have another problem. I´ll try to fix by myself.
Even though you dint not explained your second problem here, still i would like to suggest you to change your calculated dimension to
if(aggr(isnull(values)<>-1,group_xy),group_xy) and try.
Else try to use isnull() function in expression itself.
I hope this should solev your problem.
check and let us know if it works