4 Replies Latest reply: May 25, 2016 2:56 AM by Gysbert Wassenaar RSS

    Can I use variables in a Formula in Qlik Sense, see example below?

    Patrik Heldner

      Dear all,

       

      I would like to calculate the result of the margin in % fin a table, using the below variable

       

      Sum({$<[Prof-Gen Staffing unité]={'PS'}>} v_Margin_%_YTD)


      Result should by like this:


      Industry          PS     GS

      A                    18%     20%

      B                    10%     15%

      C                    30%     14%        


      Thanks for your help!