Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Distribute participation

Hi all,

I am looking to distribute participation in an object. I have been struggling build this table any clue?

Ob_IDOwner

Participation

(Expected expression)

12Alan0,33
12Joan0,33
12Laura0,33
14Alan1
15Sebastian0,5
15Laura0,5

Thanks in advance.-

1 Reply
Not applicable
Author

Imediatly I posted the solution came up, here I share it:

participation = 1 / AGGR(NODISTINCT COUNT(DISTINCT Owner), Ob_ID)

Thanks anyway.-