https://community.qlik.com/t5/QlikView/Timeseries-with-zero-values/m-p/1791736#M1210734 <DIV class="FFpbKc">&nbsp;</DIV><P><SPAN class="JLqJ4b ChMk0b">Hi,</SPAN></P><P><SPAN class="JLqJ4b ChMk0b">I am trying to create a complete time series.</SPAN></P><P><SPAN class="JLqJ4b ChMk0b">The number is calculated from Count (Distinct (document)).</SPAN></P><P><SPAN class="JLqJ4b ChMk0b">I implemented the time series as a "detached" dimension.</SPAN></P><TABLE border="1"><TBODY><TR><TD>Time</TD><TD>Count</TD></TR><TR><TD>00:00 - 00:59</TD><TD>1</TD></TR><TR><TD>01:00 - 01:59</TD><TD>2</TD></TR><TR><TD>02:00 - 02:59</TD><TD>5</TD></TR><TR><TD>03:00 - 03:39</TD><TD>23</TD></TR><TR><TD>04:00 - 04:59</TD><TD>54</TD></TR><TR><TD>....</TD><TD>&nbsp;</TD></TR><TR><TD>23:00 - 23:59</TD><TD>12</TD></TR></TBODY></TABLE><P><SPAN class="JLqJ4b ChMk0b">My problem now is that the time series no longer shows positions with count = 0.</SPAN></P><P><SPAN>T</SPAN><SPAN class="JLqJ4b ChMk0b">he number of positions should also be retained if, for example, a product should be selected.</SPAN></P><P><SPAN class="JLqJ4b ChMk0b">Only the number calculation should react to the selections.</SPAN> <SPAN class="JLqJ4b ChMk0b">Thanks for your support.</SPAN></P> Wed, 17 Mar 2021 06:17:20 GMT ThomasKrummenacher 2021-03-17T06:17:20Z https://community.qlik.com/t5/QlikView/Timeseries-with-zero-values/m-p/1791736#M1210734 <DIV class="FFpbKc">&nbsp;</DIV><P><SPAN class="JLqJ4b ChMk0b">Hi,</SPAN></P><P><SPAN class="JLqJ4b ChMk0b">I am trying to create a complete time series.</SPAN></P><P><SPAN class="JLqJ4b ChMk0b">The number is calculated from Count (Distinct (document)).</SPAN></P><P><SPAN class="JLqJ4b ChMk0b">I implemented the time series as a "detached" dimension.</SPAN></P><TABLE border="1"><TBODY><TR><TD>Time</TD><TD>Count</TD></TR><TR><TD>00:00 - 00:59</TD><TD>1</TD></TR><TR><TD>01:00 - 01:59</TD><TD>2</TD></TR><TR><TD>02:00 - 02:59</TD><TD>5</TD></TR><TR><TD>03:00 - 03:39</TD><TD>23</TD></TR><TR><TD>04:00 - 04:59</TD><TD>54</TD></TR><TR><TD>....</TD><TD>&nbsp;</TD></TR><TR><TD>23:00 - 23:59</TD><TD>12</TD></TR></TBODY></TABLE><P><SPAN class="JLqJ4b ChMk0b">My problem now is that the time series no longer shows positions with count = 0.</SPAN></P><P><SPAN>T</SPAN><SPAN class="JLqJ4b ChMk0b">he number of positions should also be retained if, for example, a product should be selected.</SPAN></P><P><SPAN class="JLqJ4b ChMk0b">Only the number calculation should react to the selections.</SPAN> <SPAN class="JLqJ4b ChMk0b">Thanks for your support.</SPAN></P> Wed, 17 Mar 2021 06:17:20 GMT https://community.qlik.com/t5/QlikView/Timeseries-with-zero-values/m-p/1791736#M1210734 ThomasKrummenacher 2021-03-17T06:17:20Z