0 Replies Latest reply: Mar 26, 2018 6:39 AM by Monika M RSS

    Dimension calculation on a metric based on other selected dimensions

    Monika M

      Hi All,

       

      I have 4 levels in my data and a dimension that I should treat as a metric. I also have a numeric metric in my dimension and sum or total is calculated on this metric. The dimension with max value of sum(Metric) should appear in the Dominant_Status column and it should be dynamic. In the sense the dominant dimension will change based on the level of the data selected,

       

      for example if only Level 1 is selected then the metric is summed up and for each Level 1 value, the dominant dimension or the dimension with the maximum value of metric should be dominant dimension for the whole bunch of Level 1 values. Dominant dimension will change based on the calculation of the metric again if the new levels are added(level 2, level 3 or level 4, please refer to the excel file attached.)

      I should be able to perform this in Qlik Sense back end code.

       

      Thank you in advance.

          

      Level 1DimensionMetricDominant_Dimension
      ADim_1847506Dim_2
      ADim_22437732Dim_2
      ADim_3818271Dim_2
      ADim_41291719Dim_2
      ADim_52266017Dim_2
      BDim_11955494Dim_2
      BDim_22770021Dim_2
      BDim_31012535Dim_2
      BDim_4419855Dim_2
      BDim_51242944Dim_2
      CDim_12444358Dim_1
      CDim_2720124Dim_1
      CDim_31371732Dim_1
      CDim_4764418Dim_1
      CDim_51786581Dim_1
      DDim_12759685Dim_1
      DDim_2836929Dim_1
      DDim_32049795Dim_1
      DDim_42023703Dim_1
      DDim_5415765Dim_1

       

      Thanks,

      Monika