Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Pivot Table Disappears when no data associated

Hello, I am running version April 2018. I have a pivot table that disappears completely when there is no data associated with the selections made. I would expect the column headers and filters (top left corner of pivot table) to still show, but the whole pivot table disappears. Is this expected?

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

I submitted a case with Qlik Support and this is not an expected feature of the pivot table. They are going to request this to be fixed in a future release.

View solution in original post

9 Replies
Highlighted
Creator III
Creator III

Hi,

Check Include Null values under all dimensions

Highlighted
Creator II
Creator II

I don't want to include NULL values though.

Highlighted
Partner
Partner

It's not expected. The headers must appear anyway...  I'd to recreate the table, or put conditions like 1=1 to show it all the time.

Are you using any expressions for measures or dimensions?

Highlighted
Partner
Partner

Hi Hannah,

In the begining i also faced and worried about this kind of problem , later understood it is normal.

In my App I have a pivot table that disappears completely when there is no data associated with the selections made.

you should not expect the column headers and filters (top left corner of pivot table) to still show.

pivot table disappears this is expected.

Nothing unusual it is.

this Might be Helpful to get understand the table.

thanks

PM

Highlighted
Creator II
Creator II

I tried the condition of 1=1 on it and that did not solve the issue.

Yes, I am using expressions for the measures.

Highlighted
Creator
Creator

Share your QVF File.

Highlighted
Creator II
Creator II

I cannot as it has confidential data.

Highlighted
Creator
Creator

try older versions of Qlik Sense Desktop

Highlighted
Creator II
Creator II

I submitted a case with Qlik Support and this is not an expected feature of the pivot table. They are going to request this to be fixed in a future release.

View solution in original post