Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anar_Kuliev
Partner - Contributor
Partner - Contributor

Сalculating measures for child elements (Qlik Sense)

I have a question about calculating the measure. I will describe the case:
We have [ID ЗСЛ] (completed cases) that can have many [ID СЛ] (cases).
When we display [ID ЗСЛ] , [ID СЛ] and the SUM for [ID ЗСЛ]  in the table, then the sum we have is calculated only for one [ID СЛ], for the rest 0 are displayed (Figure 1), but we need the sum of 918.22 to be displayed for all [ID СЛ] and in total it remains same. The indicator is calculated according to the formula

Sum(aggr(only([ЗСЛ-Сумма),[ID ЗСЛ])) 

Picture 1.png

Could you tell me how to make the Sum of the [ID ЗСЛ] is calculated correctly and displayed for all child elements [ID СЛ], and not just for one wit save correct total?

0 Replies