Set analysis in chart expression

[lprasanth]

Hi all,

            I would like the following expression to be solved. Any help would very much be appreciated.

                   title                                                                                                                    expression

• Number of references:                                                           Number of [Ref. Pooling] starting with Pooling theoric
• Nombre de palettes sol moyen des references :         Sum of [Nb Pal. Sol] of [Ref. Pooling] starting with Pooling theoric
• Nombre d’industriels moyen des références:              Number of average [loader] per [Number of references] 

[sunny_talwar]

I hope you know that this information won't be enough to help you... 

[wade12]

perhaps you should research the following qlik functions:

count, distinct, sum, avg.

[Brett_Bleess]

Here is a Design Blog post that may prove useful as well as Help link to Set Analysis:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

To Sunny's point, you will likely need to provide further information and best case, a sample app, in order for folks to be able to help further, but hopefully the above links may allow you to figure things out on your own.

Regards,
Brett