Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show results with zero (not null) in pivot table

Hi! 

I´m trying to display a pivot table that has a column "Quantity" with zero 0 in it.

When displaying the data through a table box I can see all the rows including thoose that have a 0 in column "Quantity".

But when diplaying the same in a pivot table all rows are shown except thoose that have 0 in column "Quantity"....

Please help me to display all rows.

Thanks in advance.

3 Replies
whiteline
Master II
Master II

Hi.

Just toggle checkbox: Chart Preferences->Presentation tab->Supress zero-values

Not applicable
Author

Hi!

Nice, but I still have a problem with theese values cause now I can see values as null that are acually not null...

Capture.PNG

When I click an article it says that the total is 2 464, but the expression says null....

Why do I get null when if it´s not? Or is it?

Thanks in advance.

whiteline
Master II
Master II

Post your expression.

And the screenshot of data model (Table Viewer) if it's not a secret.