9 Replies Latest reply: Dec 15, 2014 6:52 AM by Marco Wedel RSS

    If then condition Qlik Sense

      Hello -

       

      I have a simple Oracle table which I pulled into Qlik Sense. the columns are structured as below:

       

      VERSIONMONTHAMOUNT
      ACTUALJAN100
      ACTUALFEB200
      PLANJAN80
      PLANMAR90

       

      In Qlik Sense I am trying to use a table and create a measure for Actual as a column and one for the plan using if condition in a measure calculation. This is how I want to see it:

       

      VERSIONMONTHACTUALPLAN
      ACTUALJAN10080
      ACTUALFEB2000
      PLANMAR90

       

      I am using the following calculation under 'measure' in Qlik Sense:

       

      if (VERSION_ID='ACTUAL', Sum(AMOUNT), 0) for the Actual column and

      if (VERSION_ID='PLAN', Sum(AMOUNT), 0) FOR PLAN column but

      I don't get any numbers calculating. What am I missing? Please help.

       

      Thanks!!