Qlik Community

New to Qlik Sense

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BrianDH
Creator II
Creator II

Percentages Money Need Help

My user wants to see the percentage "used" based on two dollar amounts.   

 

num(sum(BH_AMOUNT_ACT) + SUM(BH_AMOUNT_GLA + BH_AMOUNT_GLL + BH_AMOUNT_GLQ + BH_AMOUNT_GLR + BH_AMOUNT_GLE) + SUM(BH_AMOUNT_PAY) +SUM(BH_AMOUNT_OTHER) /SUM(BH_AMOUNT_BUD)
* 100)

 

Looking for help

Labels (2)
1 Solution

Accepted Solutions
BrianDH
Creator II
Creator II
Author

 

needed to be this

sum(BH_AMOUNT_ACT + BH_AMOUNT_GLA + BH_AMOUNT_GLL + BH_AMOUNT_GLQ + BH_AMOUNT_GLR + BH_AMOUNT_GLE + BH_AMOUNT_PAY + BH_AMOUNT_OTHER)
/SUM(BH_AMOUNT_BUD)

View solution in original post

3 Replies
martinpohl
Partner
Partner

that's a mathematical problem

num(

(

sum(BH_AMOUNT_ACT) + SUM(BH_AMOUNT_GLA + BH_AMOUNT_GLL + BH_AMOUNT_GLQ + BH_AMOUNT_GLR + BH_AMOUNT_GLE) + SUM(BH_AMOUNT_PAY) +SUM(BH_AMOUNT_OTHER)

)

/SUM(BH_AMOUNT_BUD)
* 100)

 

isn't it?

Regards

BrianDH
Creator II
Creator II
Author

OK, then how do I get the percentage of (Spend/Budget)?

BrianDH
Creator II
Creator II
Author

 

needed to be this

sum(BH_AMOUNT_ACT + BH_AMOUNT_GLA + BH_AMOUNT_GLL + BH_AMOUNT_GLQ + BH_AMOUNT_GLR + BH_AMOUNT_GLE + BH_AMOUNT_PAY + BH_AMOUNT_OTHER)
/SUM(BH_AMOUNT_BUD)

View solution in original post