Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Community Browser