Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
New Contributor III

Dimension calculation on a metric based on other selected dimensions

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