topic numer in QlikView https://community.qlik.com/t5/QlikView/numer/m-p/1311012#M833766 <HTML><HEAD></HEAD><BODY><P>hi in a text box i ave taken a expression and the output is like </P><P></P><P>7623,28%</P><P></P><P>it should be like&nbsp; after 2 digits .</P><P></P><P>how do i write it ,,,iam including ##.#% </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT smilingjohn 2020-11-25T16:16:04Z numer https://community.qlik.com/t5/QlikView/numer/m-p/1311012#M833766 <HTML><HEAD></HEAD><BODY><P>hi in a text box i ave taken a expression and the output is like </P><P></P><P>7623,28%</P><P></P><P>it should be like&nbsp; after 2 digits .</P><P></P><P>how do i write it ,,,iam including ##.#% </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/numer/m-p/1311012#M833766 smilingjohn 2020-11-25T16:16:04Z Re: numer https://community.qlik.com/t5/QlikView/numer/m-p/1311013#M833768 <HTML><HEAD></HEAD><BODY><P>Try with :</P><P></P><P>Num(Your field,'# ##0.00%')</P></BODY></HTML> Mon, 05 Jun 2017 09:46:28 GMT https://community.qlik.com/t5/QlikView/numer/m-p/1311013#M833768 sergio0592 2017-06-05T09:46:28Z Re: numer https://community.qlik.com/t5/QlikView/numer/m-p/1311014#M833770 <HTML><HEAD></HEAD><BODY><P>Hi Jean Thanks </P><P>And also i wanted to know Iam using a oie chart&nbsp; with cyclic drilldown , i want to sort&nbsp; the expression how do i do it ...becuase under sort the expression is disabled </P></BODY></HTML> Mon, 05 Jun 2017 09:48:17 GMT https://community.qlik.com/t5/QlikView/numer/m-p/1311014#M833770 smilingjohn 2017-06-05T09:48:17Z Re: numer https://community.qlik.com/t5/QlikView/numer/m-p/1311015#M833772 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Right Click Chart Properties&gt;Dimensions&gt;Edit Groups&gt;Your Groups&gt;Edit&gt;Sort Orders&gt;Ok&gt;Ok&gt;Ok</P><P></P><P></P><P></P><P>Hope it helps!!</P></BODY></HTML> Mon, 05 Jun 2017 09:55:38 GMT https://community.qlik.com/t5/QlikView/numer/m-p/1311015#M833772 Anonymous 2017-06-05T09:55:38Z Re: numer https://community.qlik.com/t5/QlikView/numer/m-p/1311016#M833774 <HTML><HEAD></HEAD><BODY><P>Hi Anil ,</P><P>I did it as per your suggestions ...But i see the pie chart displays the legends as per the amuont of percentage ..greater the percentage first is the legend being displayed . </P><P>I have sorted like </P><P>Blocker,Critical,High,Medium,Low Unassigned </P><P>and n the chart i see it like this as shown in the image</P><P><IMG alt="Pie.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165758_Pie.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 05 Jun 2017 10:11:38 GMT https://community.qlik.com/t5/QlikView/numer/m-p/1311016#M833774 smilingjohn 2017-06-05T10:11:38Z Re: numer https://community.qlik.com/t5/QlikView/numer/m-p/1311017#M833776 <HTML><HEAD></HEAD><BODY><P>yes, but how can achieve my sorting order as per the epression i have writen ?</P></BODY></HTML> Mon, 05 Jun 2017 10:36:59 GMT https://community.qlik.com/t5/QlikView/numer/m-p/1311017#M833776 smilingjohn 2017-06-05T10:36:59Z Re: numer https://community.qlik.com/t5/QlikView/numer/m-p/1311018#M833778 <HTML><HEAD></HEAD><BODY><P>So your sort is per amount percentage. Unassigned is the bigest part, medium the second,...</P><P></P><P>You want sort Blocker in first, Critical in second,High in third, ....&nbsp; Is it that you're trying to achieve?</P></BODY></HTML> Mon, 05 Jun 2017 11:23:09 GMT https://community.qlik.com/t5/QlikView/numer/m-p/1311018#M833778 sergio0592 2017-06-05T11:23:09Z Re: numer https://community.qlik.com/t5/QlikView/numer/m-p/1311019#M833780 <HTML><HEAD></HEAD><BODY><P>yes i want the legends to be displayed like </P><P>Blocled</P><P>Crictical</P><P>High</P><P>Medim</P><P>Low</P><P>and thats the reason i wrote the expression like </P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">match(Blocker,Critical,High,Medium,Low Unassigned) </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Mon, 05 Jun 2017 11:39:00 GMT https://community.qlik.com/t5/QlikView/numer/m-p/1311019#M833780 smilingjohn 2017-06-05T11:39:00Z Re: numer https://community.qlik.com/t5/QlikView/numer/m-p/1311020#M833782 <HTML><HEAD></HEAD><BODY><P>I think it's because you miss simple quotes, try:</P><P></P><P>=match(Priority, 'Blocker','Critical','High','Medium','Low','Unassigned') </P></BODY></HTML> Mon, 05 Jun 2017 12:01:48 GMT https://community.qlik.com/t5/QlikView/numer/m-p/1311020#M833782 sergio0592 2017-06-05T12:01:48Z Re: numer https://community.qlik.com/t5/QlikView/numer/m-p/1311021#M833784 <HTML><HEAD></HEAD><BODY><P>you can try to display numbers/percentage in legends as inside chart numbers are collapsed or you can try to arrange it by ctrl+alt</P></BODY></HTML> Mon, 05 Jun 2017 15:20:54 GMT https://community.qlik.com/t5/QlikView/numer/m-p/1311021#M833784 tajmohamed30 2017-06-05T15:20:54Z Re: numer https://community.qlik.com/t5/QlikView/numer/m-p/1311022#M833786 <HTML><HEAD></HEAD><BODY><P>Can you give us your full expression you are using? </P></BODY></HTML> Mon, 05 Jun 2017 16:37:21 GMT https://community.qlik.com/t5/QlikView/numer/m-p/1311022#M833786 vishsaggi 2017-06-05T16:37:21Z