Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nurulizzaty
Contributor III
Contributor III

Change value to percentage

Hello experts,

I have this expression to detect either the case is accident or not, then i will display the factor of the case. BUT, how do i display the value as in percentage? 

Count({$<[INCIDENT_TYPE]={'Accident'}>}FACTOR_1)

The percentage should calculate by num of factor/total factor * 100 right? But how do i write it with the expression above?

Need your help asap. Thank you so much.

Regards,

Zety

1 Solution

Accepted Solutions
UserID2626
Partner - Creator III
Partner - Creator III

(Count({$<[INCIDENT_TYPE]={'Accident'}>}FACTOR_1) / Count( Total {$<[INCIDENT_TYPE]=>}FACTOR_1))*100

or

(Count({$<[INCIDENT_TYPE]={'Accident'}>}FACTOR_1) / Count( Total {$<[INCIDENT_TYPE]=>}FACTOR_1))

and change number format to %

View solution in original post

2 Replies
UserID2626
Partner - Creator III
Partner - Creator III

(Count({$<[INCIDENT_TYPE]={'Accident'}>}FACTOR_1) / Count( Total {$<[INCIDENT_TYPE]=>}FACTOR_1))*100

or

(Count({$<[INCIDENT_TYPE]={'Accident'}>}FACTOR_1) / Count( Total {$<[INCIDENT_TYPE]=>}FACTOR_1))

and change number format to %

nurulizzaty
Contributor III
Contributor III
Author

THANK YOU SOOOOOOO MUCH! 

You save my life! May God bless you alwaysssss 🙂