https://community.qlik.com/t5/QlikView/Null-Issue/m-p/1634496#M508371 <P>Hi,</P><P>&nbsp;</P><P>1. what you want to display?</P><P>2. you want show as Pivot Table or Chart?</P><P>3. Explain your Expression.</P><P>&nbsp;</P><P>K. Srinivasan.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 12 Oct 2019 08:26:17 GMT Ksrinivasan 2019-10-12T08:26:17Z https://community.qlik.com/t5/QlikView/Null-Issue/m-p/1594642#M508370 <P>&nbsp;Hello!&nbsp;<span class="lia-unicode-emoji" title=":grinning_face:">😀</span></P><P><BR /><SPAN>can somebody please explain to me</SPAN>, how to solve this trouble please<BR /><BR />i have a matrix with 2 dimension from the same table, but i´m having issues when the expression calculated value is 0; it is grouped in a 0 Category and do not appear on the corresponding "Madre" dimension. I need the 0 values to be displayed in the corresponding "Madre" dimension.</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captura.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14178i3FC172A42B5D0D77/image-size/large?v=v2&amp;px=999" role="button" title="Captura.PNG" alt="Captura.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captura1.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14176i9E31E9DA1774CF14/image-size/large?v=v2&amp;px=999" role="button" title="Captura1.PNG" alt="Captura1.PNG" /></span></P><P>Here are the tables</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captura3.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14175i428CB22AA078A5B3/image-size/medium?v=v2&amp;px=400" role="button" title="Captura3.PNG" alt="Captura3.PNG" /></span></P><P>And the "Cuentas" table. The two selected are the dimensions in the matrix</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captura4.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14177iCAE8A078BE366412/image-size/medium?v=v2&amp;px=400" role="button" title="Captura4.PNG" alt="Captura4.PNG" /></span></P><P>The expression is :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Captura5.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14180i08E99096AEBA7D5F/image-size/large?v=v2&amp;px=999" role="button" title="Captura5.PNG" alt="Captura5.PNG" /></span></P><P>&nbsp;</P><P>where "MesActual" and "AñoActual" are variables that select the correct month and year.</P><P>&nbsp;</P><P>Can somebody help me with this?&nbsp;</P><P>&nbsp;</P><P>Thanks in advance</P> Sat, 16 Nov 2024 20:36:52 GMT https://community.qlik.com/t5/QlikView/Null-Issue/m-p/1594642#M508370 indiana256 2024-11-16T20:36:52Z https://community.qlik.com/t5/QlikView/Null-Issue/m-p/1634496#M508371 <P>Hi,</P><P>&nbsp;</P><P>1. what you want to display?</P><P>2. you want show as Pivot Table or Chart?</P><P>3. Explain your Expression.</P><P>&nbsp;</P><P>K. Srinivasan.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 12 Oct 2019 08:26:17 GMT https://community.qlik.com/t5/QlikView/Null-Issue/m-p/1634496#M508371 Ksrinivasan 2019-10-12T08:26:17Z