Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.