Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

0 Replies