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?

      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!