https://community.qlik.com/t5/QlikView/why-the-zero-data-shows-in-pivot-table-but-not-showing-in-a/m-p/1542604#M508477 <P>Hi Guru,</P><P>&nbsp;</P><P>Any one can help on this chart? below line chart doesn't show week 1 value (which should be zero)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture22.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5717iF0378882E67F3660/image-size/large?v=v2&amp;px=999" role="button" title="Capture22.PNG" alt="Capture22.PNG" /></span></P><P>&nbsp;</P><P>If I switch it to pivot table, it will show the week 1 value. Why???</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture333.PNG" style="width: 822px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5720i014035A93A6ADE5C/image-size/large?v=v2&amp;px=999" role="button" title="Capture333.PNG" alt="Capture333.PNG" /></span>Here is the expression: so basically I compare each week value increase % or decrease % against week 1 value.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture32.PNG" style="width: 893px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5719iF6595BD1FEC0DDFB/image-size/large?v=v2&amp;px=999" role="button" title="Capture32.PNG" alt="Capture32.PNG" /></span></P> Sat, 16 Nov 2024 04:29:08 GMT Nefertary 2024-11-16T04:29:08Z https://community.qlik.com/t5/QlikView/why-the-zero-data-shows-in-pivot-table-but-not-showing-in-a/m-p/1542604#M508477 <P>Hi Guru,</P><P>&nbsp;</P><P>Any one can help on this chart? below line chart doesn't show week 1 value (which should be zero)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture22.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5717iF0378882E67F3660/image-size/large?v=v2&amp;px=999" role="button" title="Capture22.PNG" alt="Capture22.PNG" /></span></P><P>&nbsp;</P><P>If I switch it to pivot table, it will show the week 1 value. Why???</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture333.PNG" style="width: 822px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5720i014035A93A6ADE5C/image-size/large?v=v2&amp;px=999" role="button" title="Capture333.PNG" alt="Capture333.PNG" /></span>Here is the expression: so basically I compare each week value increase % or decrease % against week 1 value.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture32.PNG" style="width: 893px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5719iF6595BD1FEC0DDFB/image-size/large?v=v2&amp;px=999" role="button" title="Capture32.PNG" alt="Capture32.PNG" /></span></P> Sat, 16 Nov 2024 04:29:08 GMT https://community.qlik.com/t5/QlikView/why-the-zero-data-shows-in-pivot-table-but-not-showing-in-a/m-p/1542604#M508477 Nefertary 2024-11-16T04:29:08Z https://community.qlik.com/t5/QlikView/why-the-zero-data-shows-in-pivot-table-but-not-showing-in-a/m-p/1542629#M508478 I have figured out why... Need to untick suppress zero value in the presentation tab. Tue, 12 Feb 2019 04:36:16 GMT https://community.qlik.com/t5/QlikView/why-the-zero-data-shows-in-pivot-table-but-not-showing-in-a/m-p/1542629#M508478 Nefertary 2019-02-12T04:36:16Z