Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

numer

hi in a text box i ave taken a expression and the output is like

7623,28%

it should be like  after 2 digits .

how do i write it ,,,iam including ##.#%

10 Replies
sergio0592
Specialist III
Specialist III

Try with :

Num(Your field,'# ##0.00%')

smilingjohn
Specialist
Specialist
Author

Hi Jean Thanks

And also i wanted to know Iam using a oie chart  with cyclic drilldown , i want to sort  the expression how do i do it ...becuase under sort the expression is disabled

Anonymous
Not applicable

Hi

Right Click Chart Properties>Dimensions>Edit Groups>Your Groups>Edit>Sort Orders>Ok>Ok>Ok

Hope it helps!!

smilingjohn
Specialist
Specialist
Author

Hi Anil ,

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 .

I have sorted like

Blocker,Critical,High,Medium,Low Unassigned

and n the chart i see it like this as shown in the image

Pie.PNG

smilingjohn
Specialist
Specialist
Author

yes, but how can achieve my sorting order as per the epression i have writen ?

sergio0592
Specialist III
Specialist III

So your sort is per amount percentage. Unassigned is the bigest part, medium the second,...

You want sort Blocker in first, Critical in second,High in third, ....  Is it that you're trying to achieve?

smilingjohn
Specialist
Specialist
Author

yes i want the legends to be displayed like

Blocled

Crictical

High

Medim

Low

and thats the reason i wrote the expression like

match(Blocker,Critical,High,Medium,Low Unassigned)


sergio0592
Specialist III
Specialist III

I think it's because you miss simple quotes, try:

=match(Priority, 'Blocker','Critical','High','Medium','Low','Unassigned')

tajmohamed30
Creator III
Creator III

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