Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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 - Specialist
Partner - Specialist

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

Anonymous
Not applicable
Author

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

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

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