topic Re: Expression Total Help in QlikView

Expression Total Help

Anonymous — Thu, 05 Oct 2017 02:37:20 GMT

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

Re: Expression Total Help

sunny_talwar — Thu, 05 Oct 2017 11:53:03 GMT

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)

Re: Expression Total Help

Anonymous — Thu, 05 Oct 2017 21:12:31 GMT

Thanks again Sunny!