Pivot Table Disappears when no data associated

[hlines_usacs]

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?

[pawwy1415]

Hi,

Check Include Null values under all dimensions

[hlines_usacs]

I don't want to include NULL values though.

[lcontezini]

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?

[praveenkumar_ma]

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

[hlines_usacs]

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

Yes, I am using expressions for the measures.

[Anonymous]

Share your QVF File.

[hlines_usacs]

I cannot as it has confidential data.

[Anonymous]

try older versions of Qlik Sense Desktop

[hlines_usacs · Accepted solution]

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.