Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
It's been awhile I haven't work on Qlikview. I come across expression total doesn't foot when dimension limits "show total" are checked for Industry and Issuer. What Im trying to do is to take "Sumproduct" column divide "Excluded Issuer" = Final Column. There are 3 Issuer been excluded, "J Soft", "Risk", and "Tan". Any information greatly appreciated!
Expected Value: for Issuer and Industry Total:
Columns:
Sumproduct - expect to show 27,239 not 26,946 (not sure how this number comes in)
Excluded Issuer - Agree with 213,284
Final - expect to show 12.77111 % not 12.63366 %
Many Thanks,
Frank
Sumproduct
=Sum(Aggr((sum({<[Flow Type]={'Cost','FX Hedging Loss'},Issuer-={'Risk','Tan','J Soft'}>}[Amount]) *-1/1000)
*
XIRR([Amount], [iDate]), Status, Industry, Issuer))
Final
=Sum(Aggr((sum({<[Flow Type]={'Cost','FX Hedging Loss'},Issuer-={'Risk','Tan','J Soft'}, [Status]=>}[Amount])*-1/1000)
*
XIRR([Amount], [iDate]), Status, Issuer, Industry))
/
(sum({<[Flow Type]={'Cost','FX Hedging Loss'},Issuer-={'Risk','Tan','J Soft'}>}[Amount])*-1/1000)
Sumproduct
=Sum(Aggr((sum({<[Flow Type]={'Cost','FX Hedging Loss'},Issuer-={'Risk','Tan','J Soft'}>}[Amount]) *-1/1000)
*
XIRR([Amount], [iDate]), Status, Industry, Issuer))
Final
=Sum(Aggr((sum({<[Flow Type]={'Cost','FX Hedging Loss'},Issuer-={'Risk','Tan','J Soft'}, [Status]=>}[Amount])*-1/1000)
*
XIRR([Amount], [iDate]), Status, Issuer, Industry))
/
(sum({<[Flow Type]={'Cost','FX Hedging Loss'},Issuer-={'Risk','Tan','J Soft'}>}[Amount])*-1/1000)
Thanks again Sunny!