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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.