topic Re: Dimensionality in Sense in App Development https://community.qlik.com/t5/App-Development/Dimensionality-in-Sense/m-p/1313599#M28128 <HTML><HEAD></HEAD><BODY><P>use this for dont have the "-" (<SPAN style="color: #000000; font-family: Calibri; font-size: 16px;">dash</SPAN><span class="lia-unicode-emoji" title=":disappointed_face:">๐Ÿ˜ž</span></P><P></P><P></P><P>IF(ISNULL([campo]) OR Round([<SPAN style="font-size: 13.3333px;">campo</SPAN>])=0,0.0,[<SPAN style="font-size: 13.3333px;">campo</SPAN>]) </P></BODY></HTML> Thu, 27 Apr 2017 22:05:54 GMT 2017-04-27T22:05:54Z Dimensionality in Sense https://community.qlik.com/t5/App-Development/Dimensionality-in-Sense/m-p/1313598#M28127 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P style="margin: 0px 0px 8pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">I made a new column in a table. For that new column, I do not want to have any total at all. I selected No Total, from the option box. It is very good except for the dash. I donโ€™t want a dash. There is no option to choose the symbol for null values. Well, I could use the function dimensionality(), but what happens; It does not work. </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P style="margin: 0px 0px 8pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Iโ€™d like to have all the functions provided working fine, in sense and in view, both.</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P style="margin: 0px 0px 8pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> T</SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">hanks.</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P></BODY></HTML> Tue, 25 Apr 2017 11:17:55 GMT https://community.qlik.com/t5/App-Development/Dimensionality-in-Sense/m-p/1313598#M28127 christian77 2017-04-25T11:17:55Z Re: Dimensionality in Sense https://community.qlik.com/t5/App-Development/Dimensionality-in-Sense/m-p/1313599#M28128 <HTML><HEAD></HEAD><BODY><P>use this for dont have the "-" (<SPAN style="color: #000000; font-family: Calibri; font-size: 16px;">dash</SPAN><span class="lia-unicode-emoji" title=":disappointed_face:">๐Ÿ˜ž</span></P><P></P><P></P><P>IF(ISNULL([campo]) OR Round([<SPAN style="font-size: 13.3333px;">campo</SPAN>])=0,0.0,[<SPAN style="font-size: 13.3333px;">campo</SPAN>]) </P></BODY></HTML> Thu, 27 Apr 2017 22:05:54 GMT https://community.qlik.com/t5/App-Development/Dimensionality-in-Sense/m-p/1313599#M28128 2017-04-27T22:05:54Z