Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW
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.-