Qlik Community

Ask a Question

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
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

Contributor III
Contributor III

Thanks worked perfect!!