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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I give percentage format to a specific row in a table.

How can I give percentage format to a specific row for the below table ?

Capture.JPG

3 Replies
stigchel
Partner - Master
Partner - Master

In the expression that calculates the percentage you can use Num with the formatting option like this

=Num(Count(Id)/Count(TOTAL Id),'0.0%')

Or go the number tab of the properties and select display as percentage for that expression

Not applicable
Author

Thank you Piet for the prompt reply,

but actually the above expression wont work, I have already tried that with percentage format.

If we are giving percentage in Number tab in properties, it will get applied to the whole column, Here i want it in a single row.

stigchel
Partner - Master
Partner - Master

Assuming then that Percentage,Test1... is a dimension you can use something like

If(YourDim='Percentage',Num(YourExpression,'0.0%'),YourExpression)