Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
lprasanth
Contributor II
Contributor II

Set analysis in chart expression

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] 
Labels (2)
3 Replies
sunny_talwar

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

wade12
Partner
Partner

perhaps you should research the following qlik functions:

count, distinct, sum, avg.

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.