Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
fabios
Contributor III
Contributor III

Computing stakes on the fly?

Hi,

 

I would like to ask for an opinion on the best way to compute stakes in Qlik.

 

I work in Financial Services. In our simplified data structure, we have three levels - funds, instruments and companies. A fund invests in one or multiple instruments, which in turn invest in one or multiple companies. Please see the diagram below.

clipboard_image_0.png

 

I'd like to compute the exposure of a fund into a company. To do this, I need to compute the stakes of the fund into each instrument which holds the company. In formulas:

clipboard_image_1.png

 

Can this be achieved directly in a chart or do I have to pre-calculate it?

 

Thanks for your help,

Fabio 

0 Replies