0 Replies Latest reply: Mar 5, 2013 4:11 AM by Andy Myers RSS

    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