25 Replies Latest reply: Mar 6, 2018 12:38 AM by Diane McDonough RSS

    Set Analysis Query

    Diane McDonough

      Hi

       

      I’m really new to Qlik Sense and am having trouble getting a simple set analysis to work.  I have a qvd of transactions that have columns including ‘Amount’ and ‘Actual_Flag’.  I want to return the amount where the actual flag is ‘A’ but although the expression is accepted by the expression editor I am getting an invalid dimension indicator.

       

      SUM(${<ACTUAL_FLAG={'A'}>}AMOUNT)

       

      Any advice would be appreciated

       

      Thanks

      Diane