New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!

Who Me Too'd this topic

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.

Who Me Too'd this topic