Switching Between Currencies - Set Analysis

Tue, 05 Mar 2013 09:11:09 GMT

Morning all,

I'm referring to an earlier post (http://community.qlik.com/message/101254#101254) but I have run into a couple of problems with it and wondering if anyone could help.

I'm trying to incorporate John's solution into my application but I'm having trouble combining it with set analysis expressions:

=$(money(Sum($<Field 1 = {'abc'}>}Field 3))) works fine but

=$(money(Sum($<Field 1 = {'abc'}, Field 2 = {'xyz'}>}Field 3))) evaluates to null

John's original solution is attached.

Any thoughts on this would be much appreciated.

Thanks,

Andy

topic Switching Between Currencies - Set Analysis in QlikView