Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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)