Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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.-

Labels (1)
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.-