Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ThomasKrummenacher
Partner - Contributor II
Partner - Contributor II

Timeseries with zero values

 

Hi,

I am trying to create a complete time series.

The number is calculated from Count (Distinct (document)).

I implemented the time series as a "detached" dimension.

TimeCount
00:00 - 00:591
01:00 - 01:592
02:00 - 02:595
03:00 - 03:3923
04:00 - 04:5954
.... 
23:00 - 23:5912

My problem now is that the time series no longer shows positions with count = 0.

The number of positions should also be retained if, for example, a product should be selected.

Only the number calculation should react to the selections. Thanks for your support.

0 Replies