Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to calculate the % in bar chart

Hi ...

for ex I have 2000 as rent cost and 200 as non-rent cost.I want to calculate the Rent cost as % of non-rent cost.

How can I put the logic here ?Thanks much.

2 Replies
t_chetirbok
Creator III
Creator III

Hi!

expression: [rent cost]*100/[non-rent cost]

for your example: 2000*100/200 = 1000 %

sunny_talwar

May be add Type of cost as your second dimension and use an expression like this:

Sum(Cost)/Sum(TOTAL <Dimesion1> Cost)