QlikView App Dev

[#1]

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.

Regards

Christian

[sathishkumar_go]

Hi

use supress null values only then i believe u can see 0 values

Thanks

Sathish

[#3]

When I use "Suppress null values" zero values are suppressed also.

Regards

Christian

[Anonymous]

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.

[sathishkumar_go]

Hi

Plz find the attachements. It ll help u

[#6]

Sathish,

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.

Regards

Christian

[sathishkumar_go]

Hi

Check this attachements.

[#8]

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.

- Sridhar

[#9]

Sridhar,

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.

Regards

Christian

[#10]

Hi christian,

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

- Sridhar