Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Honored Contributor II

Re: Show results with zero (not null) in pivot table

Hi.

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

Not applicable

Re: Show results with zero (not null) in pivot table

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
Honored Contributor II

Re: Show results with zero (not null) in pivot table

Post your expression.

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

Community Browser