Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Pivot Table Disappears when no data associated

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.

9 Replies
pawwy1415
Contributor II

Re: Pivot Table Disappears when no data associated

Hi,

Check Include Null values under all dimensions

hlines_usacs
Contributor II

Re: Pivot Table Disappears when no data associated

I don't want to include NULL values though.

lcontezini
Contributor

Re: Pivot Table Disappears when no data associated

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
Contributor

Re: Pivot Table Disappears when no data associated

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

Re: Pivot Table Disappears when no data associated

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

Yes, I am using expressions for the measures.

dilipkumard12
New Contributor II

Re: Pivot Table Disappears when no data associated

Share your QVF File.

hlines_usacs
Contributor II

Re: Pivot Table Disappears when no data associated

I cannot as it has confidential data.

dilipkumard12
New Contributor II

Re: Pivot Table Disappears when no data associated

try older versions of Qlik Sense Desktop

hlines_usacs
Contributor II

Re: Pivot Table Disappears when no data associated

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.