https://community.qlik.com/t5/QlikView/How-to-display-zero-when-there-is-no-record-for-certain-dates/m-p/1948955#M1219669 <P>Hi,</P> <P>The only way is to use a reference table of time where you have all the days. With the same name DT, link will be automatic between your fact table (Sales) and reference table.</P> <P>After, you just have to ensure that you have uncheck the 'Suppress Zero Values' in Properties/Presentation tab.</P> Tue, 28 Jun 2022 09:20:31 GMT sergio0592 2022-06-28T09:20:31Z https://community.qlik.com/t5/QlikView/How-to-display-zero-when-there-is-no-record-for-certain-dates/m-p/1948638#M1219658 <P>Hello everyone,</P> <P>I want the line of the chart to go down to zero for the dates where I don't make anys ales for example On 31/05/2022, 02-03/06/2022. And Print zero in the text box( which contains the sum of all sales of the date selected ), if I don't have sales on that date of course. How is that possible on script?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Nourrahmcnean_0-1656341427337.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82755iEDCBB2779AF83636/image-size/medium?v=v2&amp;px=400" role="button" title="Nourrahmcnean_0-1656341427337.png" alt="Nourrahmcnean_0-1656341427337.png" /></span></P> <P>&nbsp;</P> Tue, 28 Jun 2022 09:21:17 GMT https://community.qlik.com/t5/QlikView/How-to-display-zero-when-there-is-no-record-for-certain-dates/m-p/1948638#M1219658 Nourrahmcnean 2022-06-28T09:21:17Z https://community.qlik.com/t5/QlikView/How-to-display-zero-when-there-is-no-record-for-certain-dates/m-p/1948955#M1219669 <P>Hi,</P> <P>The only way is to use a reference table of time where you have all the days. With the same name DT, link will be automatic between your fact table (Sales) and reference table.</P> <P>After, you just have to ensure that you have uncheck the 'Suppress Zero Values' in Properties/Presentation tab.</P> Tue, 28 Jun 2022 09:20:31 GMT https://community.qlik.com/t5/QlikView/How-to-display-zero-when-there-is-no-record-for-certain-dates/m-p/1948955#M1219669 sergio0592 2022-06-28T09:20:31Z