Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist III
Specialist III

Show all hours even when data doesn't exist

Hello Folks,

I'm working with a Pivot Table, and I have a field that represents the Hours.  As of now, my pivot table only shows the hours for which data exists, which makes sense.  But I would also like to show all the hours (0-24) no matter  if the data exists or not.  Generally, I would create a Stub Item to fill out the data range, but that doesn't work when the user begins making selections and filtering.

Capture120.PNG

Any help is greatly appreciated.

1 Reply
rubenmarin

Hi Justin, that can happen when using a vertical and an horizontal dimension, and some of the values for the vertical dimension doesn't have any relation with the horizontal dimension.

In that case you need a certesian product to make the relations between field values, this document can help on the task:

Generating Missing Data In QlikView