Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can some one help me
I have a one Qlikview Chart Expression in that I am writing below expression but sum is not working for Total FTE at horizontal level.
=Sum(Aggr(((SUM([ASM_SSH_Hours])+SUM([ASM_RCSH_Hours])+ (SUM(AGGR([Total Service Credit Balance in Hours],[Project ID]))*0.35)) * (Avg([FTE Multiplier]))), Global, Region, Subregion, Subregion1, PSA_POCOUNTRY))
Example:
Region ASMFTE TAMFTE TotalFTE
WW 500 400 it should give me 900 but it's not working.
Region ASMFTE TAMFTE TotalFTE
AMS 500 400 it should give me 900 but it's not working.
APJ 300 200 it should give me 500 but its not working
EMEA 100 100 it should give me 200 but its not working
it works at vertical level(column level)
Region ASMFTE TAMFTE TotalFTE
AMS 500 400 it should give me 900 but it's not working.
APJ 300 200 it should give me 500 but its not working
EMEA 100 100 it should give me 200 but its not working
Total 900 700 vertical its working correctly-----------no problem at vertical sum.
attaching QVW For Your Reference.
Please advise.
Best Regards,
HK
May be try this for Total FTE
Column(1) +
Column(2) +
Column(3) +
Column(4) +
Column(5) +
Column(6)
May be try this for Total FTE
Column(1) +
Column(2) +
Column(3) +
Column(4) +
Column(5) +
Column(6)
Hi Sunny,
Yes, Same I implemented. 🙂
Thank You.
Best Regards,
Hari