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

how to apply % sign to calculated expression

%

KK
9 Replies
Anonymous
Not applicable

goto tab number and define it as percent

Karim_Khan
Creator III
Creator III
Author

But values getting changed.Correct values is 16 but after applying with % its showing as 1,600%

KK
Not applicable

Go to Number Tab and Check Show in percent Number formatting.

marcus_malinow
Partner - Specialist III
Partner - Specialist III

ok, so divide your expression by 100, and show in percent

Karim_Khan
Creator III
Creator III
Author

my value is getting correct data but I want show this in %.

KK
antoniotiman
Master III
Master III

=Sum(Value)&' %'

awhitfield
Partner - Champion
Partner - Champion

You may be best served by uploading a sample qvw? So community members can SEE what you are referring too!

Andy

Karim_Khan
Creator III
Creator III
Author

Tnx its working now

KK
Not applicable

Hi,

You can Try using the Num Function : Num ('Expression', '#,##0.00%') {Modify as required}

OR

={Your Percentage Expression} & '%'

OR

{Your Expression without multiplying by 100} -> go to Numbers Tab and check SHOW as Percentage.

Hope it helps !

Cheers !