topic Re: Set analysis in chart expression in QlikView

Set analysis in chart expression

lprasanth — Sat, 16 Nov 2024 02:32:55 GMT

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]

Re: Set analysis in chart expression

sunny_talwar — Fri, 06 Sep 2019 11:15:13 GMT

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

Re: Set analysis in chart expression

wade12 — Fri, 06 Sep 2019 12:09:09 GMT

perhaps you should research the following qlik functions:

count, distinct, sum, avg.

Re: Set analysis in chart expression

Brett_Bleess — Thu, 19 Sep 2019 14:11:01 GMT

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/SetAnalysis/set-analysis-expressions.htm

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