How to calculate percentage in qliksense?

[nurulizzaty]

 Hello experts, I want to calculate the percentage of Damage as below.

But the Damage is purely from Mode expression accident type. The percentage of Damage is 

= Total Accident Type / Total Incident Type * 100. 

How do i convert above calculations in qliksense? 

Plus, how do i display the most incident prone hours based only the highest accident type instead of mode for all accident type. 

Really need your help guys asap. Thanks in advance 🙂 

[JordyWegman]

Hi,

You can change the number format to percentage in the measure. Or do the following:

=Num(Total Accident Type / Total Incident Type,'#.#%')

The number of hashtags after the . specify the number of characters behind the dot.

Jordy

Climber

[nurulizzaty]

why there is error when i try the expression you've suggested ya? 

[jonathandienst]

Enclose the field names in square brackets or quotes:

=Num([Total Accident Type] / [Total Incident Type], '#.#%', '.')

[JordyWegman]

I haven't put the brackets around your fields:

=Num([Total Accident Type] / [Total Incident Type],'#.#%')

Jordy

Climber 

[nurulizzaty]

Thank you for correcting that. There is no error in that expression but the value cannot be displayed. I mean it doesn't calculate the number 😞