Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

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
Creator III
Creator III
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

qlikviewnovice
Specialist II
Specialist II

Hi

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

Hope it helps!!

smilingjohn
Creator III
Creator III
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
Creator III
Creator III
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
Creator III
Creator III
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