topic Re: Calculated dimension - value null in QlikView https://community.qlik.com/t5/QlikView/Calculated-dimension-value-null/m-p/291019#M108042 <HTML><HEAD></HEAD><BODY><P> of course!&nbsp; the dimension is "PROBLEM"</P></BODY></HTML> Tue, 19 Jul 2011 15:51:12 GMT 2011-07-19T15:51:12Z Calculated dimension - value null https://community.qlik.com/t5/QlikView/Calculated-dimension-value-null/m-p/291017#M108040 <HTML><HEAD></HEAD><BODY><DIV> When "Valore" is null, this expression is not valid.<SPAN style="font-size: 8pt;"><DIV>= <SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Um</SPAN><SPAN style="font-size: 8pt;"> = 'EU' </SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Valore]</SPAN><SPAN style="font-size: 8pt;">))/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Um</SPAN><SPAN style="font-size: 8pt;"> = 'LT' </SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Valore]</SPAN><SPAN style="font-size: 8pt;">)), </SPAN><SPAN style="color: #800000; font-size: 8pt;">Mese</SPAN><SPAN style="font-size: 8pt;">)</SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 10pt;">so it return "-" but all calculated dimensions that follow it are not showed.......</SPAN></DIV><DIV><SPAN style="font-size: 10pt;"> </SPAN></DIV><SPAN style="font-size: 8pt;"><DIV> </DIV></SPAN>When I move back this dimension, I can see the others </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 10pt;">What I can do? </SPAN></DIV><DIV><SPAN style="font-size: 10pt;">thank's for your help!</SPAN></DIV></BODY></HTML> Tue, 19 Jul 2011 14:32:45 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-value-null/m-p/291017#M108040 2011-07-19T14:32:45Z Calculated dimension - value null https://community.qlik.com/t5/QlikView/Calculated-dimension-value-null/m-p/291018#M108041 <HTML><HEAD></HEAD><BODY><P> Please post a sample QVW so that your solution can be evaluated.</P></BODY></HTML> Tue, 19 Jul 2011 15:05:13 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-value-null/m-p/291018#M108041 ToniKautto 2011-07-19T15:05:13Z Re: Calculated dimension - value null https://community.qlik.com/t5/QlikView/Calculated-dimension-value-null/m-p/291019#M108042 <HTML><HEAD></HEAD><BODY><P> of course!&nbsp; the dimension is "PROBLEM"</P></BODY></HTML> Tue, 19 Jul 2011 15:51:12 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-value-null/m-p/291019#M108042 2011-07-19T15:51:12Z Re: Calculated dimension - value null https://community.qlik.com/t5/QlikView/Calculated-dimension-value-null/m-p/291020#M108043 <HTML><HEAD></HEAD><BODY><P>I have solved this problem using condition If....</P><P>= If(<SPAN style="color: #800000; font-size: 8pt;">Um</SPAN><SPAN style="font-size: 8pt;"> = 'EU'&nbsp; and</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Valore] &gt;=0, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Um</SPAN><SPAN style="font-size: 8pt;"> = 'EU' </SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Valore]</SPAN><SPAN style="font-size: 8pt;">))/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Um</SPAN><SPAN style="font-size: 8pt;"> = 'LT' </SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Valore]</SPAN><SPAN style="font-size: 8pt;">)), </SPAN><SPAN style="color: #800000; font-size: 8pt;">Mese</SPAN><SPAN style="font-size: 8pt;">), 0)</SPAN></P></BODY></HTML> Wed, 20 Jul 2011 13:11:38 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-value-null/m-p/291020#M108043 2011-07-20T13:11:38Z