topic Re: Format value in QlikView https://community.qlik.com/t5/QlikView/Format-value/m-p/1292015#M871487 <HTML><HEAD></HEAD><BODY><P>I FOUND:</P><P></P><P>If (MisuraOrdinamento = 1 ,Num(Valore, '#.##0'), </P><P>If (MisuraOrdinamento = 2 ,Num(Valore, '#.##0'), </P><P>If (MisuraOrdinamento = 3 ,Num(Valore, '#.##0,<STRONG>00</STRONG>'), </P><P>)))</P><P></P><P>I have the problem of TOTALS <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span> thanks</P></BODY></HTML> Tue, 22 Nov 2016 16:30:11 GMT clovati 2016-11-22T16:30:11Z Format value https://community.qlik.com/t5/QlikView/Format-value/m-p/1292014#M871486 <HTML><HEAD></HEAD><BODY><P>Hi all. In this Example I wish to display the yellow value with decimal.</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144533_Capture.PNG" style="height: auto;" /></P><P></P><P>I wrote this </P><P>If (MisuraOrdinamento = 1 ,Num(Valore, '#.##0'), </P><P>If (MisuraOrdinamento = 2 ,Num(Valore, '#.##0'), </P><P>If (MisuraOrdinamento = 3 ,Num(Valore, '#.##0,##'), </P><P>)))</P><P></P><P>but it didn't Work.</P><P>In their TOTAL I want the sum for 1 and 2 and the avarage for the 3.</P><P>THANKS in advance!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Format-value/m-p/1292014#M871486 clovati 2020-11-25T16:16:04Z Re: Format value https://community.qlik.com/t5/QlikView/Format-value/m-p/1292015#M871487 <HTML><HEAD></HEAD><BODY><P>I FOUND:</P><P></P><P>If (MisuraOrdinamento = 1 ,Num(Valore, '#.##0'), </P><P>If (MisuraOrdinamento = 2 ,Num(Valore, '#.##0'), </P><P>If (MisuraOrdinamento = 3 ,Num(Valore, '#.##0,<STRONG>00</STRONG>'), </P><P>)))</P><P></P><P>I have the problem of TOTALS <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span> thanks</P></BODY></HTML> Tue, 22 Nov 2016 16:30:11 GMT https://community.qlik.com/t5/QlikView/Format-value/m-p/1292015#M871487 clovati 2016-11-22T16:30:11Z