topic Re: Sum if not working in QlikView

Sum if not working

Wed, 25 Nov 2020 16:16:04 GMT

You see the picture above. Turnover is calculated by using this expression:

sum(If(IsNull(sub_exec_broker),trade_price*traded_amount)) <- Works fine!

Then I just want to convert it to EUR in a second column by just adding:

sum(If(IsNull(sub_exec_broker),trade_price*traded_amount/rate_eur))

And this makes it not working. Any suggestions?

sunny_talwar — Fri, 19 Aug 2016 13:25:38 GMT

Can you try this:

Sum(If(IsNull(sub_exec_broker),trade_price*traded_amount))/rate_eur

Fri, 19 Aug 2016 13:27:10 GMT

Not working, null values

kaushiknsolanki — Fri, 19 Aug 2016 13:28:21 GMT

Try this,

sum(If(IsNull(sub_exec_broker),(trade_price*traded_amount)/rate_eur))

Regards,

Kaushik Solanki

hic — Fri, 19 Aug 2016 13:28:27 GMT

This should work. So my guess is that "rate_eur" does not have a numeric interpretation.

Try IsNum(rate_eur) in a list box just to see what you get...

HIC