topic PivotTable Diagram does not show dimension with value zero in QlikView https://community.qlik.com/t5/QlikView/PivotTable-Diagram-does-not-show-dimension-with-value-zero/m-p/1832490#M1214680 <P>Hi,</P><P>I'm relatively new to QlikView and need your help!</P><P>I have data that should be aggregated by a certain criteria (Therapieklasse).</P><P>Therapieklasse can have 11 expressions (A, B, C, D, E, F, G, H, K, L, M).</P><P>Please see table below that describes the data structure of the input data in a simple way.</P><TABLE border="1"><TBODY><TR><TD><STRONG>Patienten-ID</STRONG></TD><TD><STRONG>Datum</STRONG></TD><TD><STRONG>Therapieklasse</STRONG></TD></TR><TR><TD>111</TD><TD>01.01.2021</TD><TD>A</TD></TR><TR><TD>111</TD><TD>01.01.2021</TD><TD>B</TD></TR><TR><TD>222</TD><TD>02.01.2021</TD><TD>A</TD></TR><TR><TD>222</TD><TD>02.01.2021</TD><TD>C</TD></TR><TR><TD>333</TD><TD>03.01.2021</TD><TD>D</TD></TR><TR><TD>444</TD><TD>03.01.2021</TD><TD>E</TD></TR><TR><TD>444</TD><TD>04.01.2021</TD><TD>F</TD></TR><TR><TD>555</TD><TD>04.01.2021</TD><TD>H</TD></TR><TR><TD>555</TD><TD>05.01.2021</TD><TD>K</TD></TR><TR><TD>555</TD><TD>05.01.2021</TD><TD>L</TD></TR><TR><TD>666</TD><TD>05.01.2021</TD><TD>M</TD></TR><TR><TD>666</TD><TD>05.01.2021</TD><TD>B</TD></TR><TR><TD>777</TD><TD>06.01.2021</TD><TD>B</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In the Diagram I want to display data like this:</P><TABLE border="1"><TBODY><TR><TD><STRONG>Therapieklasse</STRONG></TD><TD><STRONG>Number of Patients with certain Therapieklasse</STRONG></TD><TD><STRONG>Number of Patients with certain Therapieklasse divided by number of all Patients (= 7 Patients) </STRONG></TD><TD><STRONG>Benchmark</STRONG></TD></TR><TR><TD>A</TD><TD>2</TD><TD>28,57%</TD><TD>30%</TD></TR><TR><TD>B</TD><TD>3</TD><TD>42,86%</TD><TD>50%</TD></TR><TR><TD>C</TD><TD>1</TD><TD>14,29%</TD><TD>20%</TD></TR><TR><TD>D</TD><TD>1</TD><TD>14,29%</TD><TD>20%</TD></TR><TR><TD>E</TD><TD>1</TD><TD>14,29%</TD><TD>15%</TD></TR><TR><TD>F</TD><TD>1</TD><TD>14,29%</TD><TD>20%</TD></TR><TR><TD><FONT color="#FF0000">G</FONT></TD><TD><FONT color="#FF0000">0</FONT></TD><TD><FONT color="#FF0000">0%</FONT></TD><TD><FONT color="#FF0000">5%</FONT></TD></TR><TR><TD>H</TD><TD>1</TD><TD>14,29%</TD><TD>10%</TD></TR><TR><TD>I</TD><TD>1</TD><TD>14,29%</TD><TD>5%</TD></TR><TR><TD>K</TD><TD>1</TD><TD>14,29%</TD><TD>20%</TD></TR><TR><TD>L</TD><TD>1</TD><TD>14,29%</TD><TD>25%</TD></TR><TR><TD>M</TD><TD>1</TD><TD>14,29%</TD><TD>15%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Benchmark data is connected by Therapieklasse and values do not change.</P><P>As you can see in my example data, there is no Patient with Therapieklasse G.</P><P>Unfortunately my pivot diagram does not show the "0" for Therapieklasse G and the Benchmark value of 5%. The line for Therapieklasse G (in the table above marked red) does not even exist.</P><P>How can I solve the problem, so that both Benchmark and Number of Patients with Therapieklasse G are shown even if there is no Patient with Therapieklasse G?</P><P>Thank you very much in advance!</P><P>Best regards, Stefanie</P> Tue, 31 Aug 2021 12:11:02 GMT stefanie_a 2021-08-31T12:11:02Z PivotTable Diagram does not show dimension with value zero https://community.qlik.com/t5/QlikView/PivotTable-Diagram-does-not-show-dimension-with-value-zero/m-p/1832490#M1214680 <P>Hi,</P><P>I'm relatively new to QlikView and need your help!</P><P>I have data that should be aggregated by a certain criteria (Therapieklasse).</P><P>Therapieklasse can have 11 expressions (A, B, C, D, E, F, G, H, K, L, M).</P><P>Please see table below that describes the data structure of the input data in a simple way.</P><TABLE border="1"><TBODY><TR><TD><STRONG>Patienten-ID</STRONG></TD><TD><STRONG>Datum</STRONG></TD><TD><STRONG>Therapieklasse</STRONG></TD></TR><TR><TD>111</TD><TD>01.01.2021</TD><TD>A</TD></TR><TR><TD>111</TD><TD>01.01.2021</TD><TD>B</TD></TR><TR><TD>222</TD><TD>02.01.2021</TD><TD>A</TD></TR><TR><TD>222</TD><TD>02.01.2021</TD><TD>C</TD></TR><TR><TD>333</TD><TD>03.01.2021</TD><TD>D</TD></TR><TR><TD>444</TD><TD>03.01.2021</TD><TD>E</TD></TR><TR><TD>444</TD><TD>04.01.2021</TD><TD>F</TD></TR><TR><TD>555</TD><TD>04.01.2021</TD><TD>H</TD></TR><TR><TD>555</TD><TD>05.01.2021</TD><TD>K</TD></TR><TR><TD>555</TD><TD>05.01.2021</TD><TD>L</TD></TR><TR><TD>666</TD><TD>05.01.2021</TD><TD>M</TD></TR><TR><TD>666</TD><TD>05.01.2021</TD><TD>B</TD></TR><TR><TD>777</TD><TD>06.01.2021</TD><TD>B</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In the Diagram I want to display data like this:</P><TABLE border="1"><TBODY><TR><TD><STRONG>Therapieklasse</STRONG></TD><TD><STRONG>Number of Patients with certain Therapieklasse</STRONG></TD><TD><STRONG>Number of Patients with certain Therapieklasse divided by number of all Patients (= 7 Patients) </STRONG></TD><TD><STRONG>Benchmark</STRONG></TD></TR><TR><TD>A</TD><TD>2</TD><TD>28,57%</TD><TD>30%</TD></TR><TR><TD>B</TD><TD>3</TD><TD>42,86%</TD><TD>50%</TD></TR><TR><TD>C</TD><TD>1</TD><TD>14,29%</TD><TD>20%</TD></TR><TR><TD>D</TD><TD>1</TD><TD>14,29%</TD><TD>20%</TD></TR><TR><TD>E</TD><TD>1</TD><TD>14,29%</TD><TD>15%</TD></TR><TR><TD>F</TD><TD>1</TD><TD>14,29%</TD><TD>20%</TD></TR><TR><TD><FONT color="#FF0000">G</FONT></TD><TD><FONT color="#FF0000">0</FONT></TD><TD><FONT color="#FF0000">0%</FONT></TD><TD><FONT color="#FF0000">5%</FONT></TD></TR><TR><TD>H</TD><TD>1</TD><TD>14,29%</TD><TD>10%</TD></TR><TR><TD>I</TD><TD>1</TD><TD>14,29%</TD><TD>5%</TD></TR><TR><TD>K</TD><TD>1</TD><TD>14,29%</TD><TD>20%</TD></TR><TR><TD>L</TD><TD>1</TD><TD>14,29%</TD><TD>25%</TD></TR><TR><TD>M</TD><TD>1</TD><TD>14,29%</TD><TD>15%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Benchmark data is connected by Therapieklasse and values do not change.</P><P>As you can see in my example data, there is no Patient with Therapieklasse G.</P><P>Unfortunately my pivot diagram does not show the "0" for Therapieklasse G and the Benchmark value of 5%. The line for Therapieklasse G (in the table above marked red) does not even exist.</P><P>How can I solve the problem, so that both Benchmark and Number of Patients with Therapieklasse G are shown even if there is no Patient with Therapieklasse G?</P><P>Thank you very much in advance!</P><P>Best regards, Stefanie</P> Tue, 31 Aug 2021 12:11:02 GMT https://community.qlik.com/t5/QlikView/PivotTable-Diagram-does-not-show-dimension-with-value-zero/m-p/1832490#M1214680 stefanie_a 2021-08-31T12:11:02Z Re: PivotTable Diagram does not show dimension with value zero https://community.qlik.com/t5/QlikView/PivotTable-Diagram-does-not-show-dimension-with-value-zero/m-p/1832516#M1214688 <P>I do not see&nbsp;<STRONG>Therapieklasse G&nbsp;</STRONG>in the data model.&nbsp; If you have a master list of possible&nbsp;<STRONG>Therapieklasse</STRONG> values, you can concatenate the missing values.&nbsp; In some way you need to have a dimension that contains the list of dimension values to be displayed.</P><P>&nbsp;</P><P>master_Therapieklasse:<BR />load * inline [<BR />master_Therapieklasse<BR />A<BR />B<BR />C<BR />D<BR />E<BR />F<BR />G<BR />H<BR />I<BR />J<BR />]<BR />;</P><P>data:<BR />LOAD<BR />*</P><P>FROM <A href="https://community.qlik.com/t5/QlikView-App-Dev/PivotTable-Diagram-does-not-show-dimension-with-value-zero/td-p/1832490" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/PivotTable-Diagram-does-not-show-dimension-with-value-zero/td-p/1832490</A></P><P>(html, utf8, embedded labels, table is @1)<BR />;</P><P>concatenate (data)<BR />load<BR />master_Therapieklasse as Therapieklasse<BR />resident master_Therapieklasse<BR />where not exists (Therapieklasse, master_Therapieklasse);</P><P>drop table master_Therapieklasse;</P><P>exit script;</P> Tue, 31 Aug 2021 13:11:13 GMT https://community.qlik.com/t5/QlikView/PivotTable-Diagram-does-not-show-dimension-with-value-zero/m-p/1832516#M1214688 stevejoyce 2021-08-31T13:11:13Z