topic Re: How to make missing value at dimension display some charter like 0 turn ? in QlikView https://community.qlik.com/t5/QlikView/How-to-make-missing-value-at-dimension-display-some-charter-like/m-p/1462588#M609921 <HTML><HEAD></HEAD><BODY><P>Hi Anil</P><P></P><P>Thank you very much it work fine.</P><P></P><P>By the way did you test your expression with my QVW doc ?</P><P></P><P>Paul Yeo</P></BODY></HTML> Thu, 11 Jan 2018 02:13:04 GMT paulyeo11 2018-01-11T02:13:04Z How to make missing value at dimension display some charter like 0 turn ? https://community.qlik.com/t5/QlikView/How-to-make-missing-value-at-dimension-display-some-charter-like/m-p/1462585#M609918 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Hi All</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">I have a table 1 , which is working fine,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Inventory Turn over ratio........ On hand amount</SPAN></P><P><SPAN style="font-size: 13.3333px;">1-10............................ 100,000</SPAN></P><P><SPAN style="font-size: 13.3333px;">10-20............................200,000</SPAN></P><P><SPAN style="font-size: 13.3333px;">30-100...........................400,000</SPAN></P><P><SPAN style="font-size: 13.3333px;">...&nbsp;&nbsp; ...........................600,000</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">The last row is missing value , May i know how to make the last row display as "0 turn" ?</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Hope some one can advise me.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Paul Yeo</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Thu, 11 Jan 2018 00:32:36 GMT https://community.qlik.com/t5/QlikView/How-to-make-missing-value-at-dimension-display-some-charter-like/m-p/1462585#M609918 paulyeo11 2018-01-11T00:32:36Z Re: How to make missing value at dimension display some charter like 0 turn ? https://community.qlik.com/t5/QlikView/How-to-make-missing-value-at-dimension-display-some-charter-like/m-p/1462586#M609919 <HTML><HEAD></HEAD><BODY><P>my QVW</P></BODY></HTML> Thu, 11 Jan 2018 00:33:18 GMT https://community.qlik.com/t5/QlikView/How-to-make-missing-value-at-dimension-display-some-charter-like/m-p/1462586#M609919 paulyeo11 2018-01-11T00:33:18Z Re: How to make missing value at dimension display some charter like 0 turn ? https://community.qlik.com/t5/QlikView/How-to-make-missing-value-at-dimension-display-some-charter-like/m-p/1462587#M609920 <HTML><HEAD></HEAD><BODY><P>May be add like this?</P><P></P><P><STRONG>=If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)&nbsp; &gt;0 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)&lt;10, dual('1-10',1),</STRONG></P><P><STRONG>If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) &gt;10 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)&lt;20, dual('10-20',2),</STRONG></P><P><STRONG style="font-size: 10pt;">If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) &gt;20 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)&lt;30, dual('20-30',3),</STRONG></P><P><STRONG style="font-size: 10pt;">If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) &gt;30 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)&lt;100, dual('30-100',4),</STRONG></P><P><STRONG style="font-size: 10pt;">If(Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE) &gt;100 and Aggr(SUM(C_ONHAND_AMT)/sum(B_COGS),DESC_INVENTORY_TABLE)&lt;2000, dual('100-2000',9)<SPAN style="color: #ff0000;">, Dual('0', 10)</SPAN></STRONG><SPAN style="font-size: 10pt;"><STRONG>)))))</STRONG></SPAN></P></BODY></HTML> Thu, 11 Jan 2018 01:58:30 GMT https://community.qlik.com/t5/QlikView/How-to-make-missing-value-at-dimension-display-some-charter-like/m-p/1462587#M609920 Anil_Babu_Samineni 2018-01-11T01:58:30Z Re: How to make missing value at dimension display some charter like 0 turn ? https://community.qlik.com/t5/QlikView/How-to-make-missing-value-at-dimension-display-some-charter-like/m-p/1462588#M609921 <HTML><HEAD></HEAD><BODY><P>Hi Anil</P><P></P><P>Thank you very much it work fine.</P><P></P><P>By the way did you test your expression with my QVW doc ?</P><P></P><P>Paul Yeo</P></BODY></HTML> Thu, 11 Jan 2018 02:13:04 GMT https://community.qlik.com/t5/QlikView/How-to-make-missing-value-at-dimension-display-some-charter-like/m-p/1462588#M609921 paulyeo11 2018-01-11T02:13:04Z Re: How to make missing value at dimension display some charter like 0 turn ? https://community.qlik.com/t5/QlikView/How-to-make-missing-value-at-dimension-display-some-charter-like/m-p/1462589#M609922 <HTML><HEAD></HEAD><BODY><P>No, my analysis from here <A _jive_internal="true" href="https://community.qlik.com/message/1414021#1414021" title="https://community.qlik.com/message/1414021#1414021">https://community.qlik.com/message/1414021#1414021</A></P></BODY></HTML> Thu, 11 Jan 2018 02:17:39 GMT https://community.qlik.com/t5/QlikView/How-to-make-missing-value-at-dimension-display-some-charter-like/m-p/1462589#M609922 Anil_Babu_Samineni 2018-01-11T02:17:39Z