Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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
Highlighted
Not applicable

Re: Distribute participation

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

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

Thanks anyway.-