Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Switching Between Currencies - Set Analysis

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
Labels (1)
0 Replies