topic Re: M² after a Value in a Dynamic Cross Table in QlikView https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601179#M1106490 <HTML><HEAD></HEAD><BODY><P>Si c'est ok peux tu valider ma réponse comme correcte ? Merci <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 04 Apr 2014 09:37:49 GMT yduval75 2014-04-04T09:37:49Z M² after a Value in a Dynamic Cross Table https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601175#M1106486 <HTML><HEAD></HEAD><BODY><P>Hi, I've a Dynamique Cross Table like that :</P><P></P><P>Name - Size - ...</P><P>A&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp; 25 - ...</P><P>B&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp; 26 - ...</P><P>C&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp; 27 - ...</P><P></P><P>How can i put a m² after my value in this table? In a simple table it's easy (Number -&gt; format) but in this one ....</P><P></P><P>Thx in advice,</P></BODY></HTML> Fri, 04 Apr 2014 08:48:35 GMT https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601175#M1106486 2014-04-04T08:48:35Z Re: M² after a Value in a Dynamic Cross Table https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601176#M1106487 <HTML><HEAD></HEAD><BODY><P>added a calculted dimension in dimensions tab with :</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">[Size] &amp; ' m ² ' </SPAN></P></BODY></HTML> Fri, 04 Apr 2014 08:56:28 GMT https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601176#M1106487 yduval75 2014-04-04T08:56:28Z Re: M² after a Value in a Dynamic Cross Table https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601177#M1106488 <HTML><HEAD></HEAD><BODY><P>Okay c'es nikel et comment tu réduis la précision genre à 10²-2 maximum ? (ex : 115.689698 -&gt; 115.69)</P></BODY></HTML> Fri, 04 Apr 2014 09:15:13 GMT https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601177#M1106488 2014-04-04T09:15:13Z Re: M² after a Value in a Dynamic Cross Table https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601178#M1106489 <HTML><HEAD></HEAD><BODY><P>Tu utilises la fonction Num()</P><P></P><P>Ex : Num([Size], '# ##0,00') &amp; 'm ²'</P><P></P><P>Attention c'est un espace insecable donc copie colle le format souhaité dans l'onglet nombre.</P></BODY></HTML> Fri, 04 Apr 2014 09:25:16 GMT https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601178#M1106489 yduval75 2014-04-04T09:25:16Z Re: M² after a Value in a Dynamic Cross Table https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601179#M1106490 <HTML><HEAD></HEAD><BODY><P>Si c'est ok peux tu valider ma réponse comme correcte ? Merci <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 04 Apr 2014 09:37:49 GMT https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601179#M1106490 yduval75 2014-04-04T09:37:49Z Re: M² after a Value in a Dynamic Cross Table https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601180#M1106491 <HTML><HEAD></HEAD><BODY><P>J'ai trouvé une solution pour l'arrondi :</P><P><SPAN style="color: #0000ff; font-size: 8pt;">ROUND</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Size]</SPAN><SPAN style="font-size: 8pt;">,0.01)&amp;' m²' <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /><BR /><BR /> </SPAN></P><P></P></BODY></HTML> Fri, 04 Apr 2014 09:54:21 GMT https://community.qlik.com/t5/QlikView/M-after-a-Value-in-a-Dynamic-Cross-Table/m-p/601180#M1106491 2014-04-04T09:54:21Z