1 Reply Latest reply: Apr 17, 2016 1:56 PM by Gysbert Wassenaar RSS

    calculate relative value dependent on 2 differ column values

    juthika dash

      Hi,

       

       

      *** I am using Qlik sense desktop. I am not ble to put this question in qlik sense forum.

      I have the data set is like below:

       

       

      ProductProperty1Property2valueRelative value to a
      ap1p2101
      bp1p2111.1
      cp1p2101
      dp1p2121.2
      app1pp24001
      bpp1pp24251.0625
      cpp1pp24201.05
      dpp1pp24441.11
      appp1ppp2221
      bppp1ppp2221
      cppp1ppp2221
      dppp1ppp2221
      apppp1pppp2501
      bpppp1pppp2561.12
      cpppp1pppp2571.14
      dpppp1pppp258

      1.16

       

       

      I calculated the relative value to a column, as value/ value of a(combination of property and property 2 ). And i want to calculate the relative value i have to select from the product filter. So if I select b, i should get all the values in the graph when a product is selected.

       

      I am expecting a grapp like attached pic.

      Juthika