Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
KalluruSreekanth
Contributor
Contributor

Percentage

I need percentage of every cell and the percentage should be in row wise

Example: allocated (num) / total communication (num).

 

Labels (1)
2 Replies
brunosdvs
Contributor
Contributor

After clicking on the table, on the right side pannel (properties pannel) you can add a new measure to the table through the expression editor, where you will enter the calculation (FieldName1 / FieldName2).

brunosdvs_0-1669301719561.png

Or do the same but as a Master Item, on the left side pannel, which is recommended if you want to reuse this measure in other visuals.

brunosdvs_1-1669307421108.png

vinieme12
Champion III
Champion III

as below

sum(Measurename) / sum(total <[final sub BU new]> Measurename)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.