Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 !