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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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
0 Replies