Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar chart: Display of 0 and null values

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

10 Replies
sathishkumar_go
Partner
Partner

Hi

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

Thanks

Sathish

Not applicable
Author

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

Regards

Christian

mov
Employee
Employee

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
Partner
Partner

Hi

Plz find the attachements. It ll help u

Not applicable
Author

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
Partner
Partner

Hi

Check this attachements.

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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 Big Smile

- Sridhar