Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
tsoley9262
Contributor III
Contributor III

Number formatting in Text Object

I am using an expression in a text object that looks like this ...=Count([CAV CS Domain])/Count([CAV3 CS Domain]) and they number looks like 0.72988505747126 but I want to see it in a percentage, any help would be appreciated

1 Solution

Accepted Solutions
TimvB
Creator II
Creator II

=Num(Count([CAV CS Domain])/Count([CAV3 CS Domain]),'#,##0%')

More information on the Num() function:https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/Formatting...

Hope it helps!

View solution in original post

2 Replies
TimvB
Creator II
Creator II

=Num(Count([CAV CS Domain])/Count([CAV3 CS Domain]),'#,##0%')

More information on the Num() function:https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/Formatting...

Hope it helps!

tsoley9262
Contributor III
Contributor III
Author

Thanks worked perfect!!