topic Set analysis in QlikView

Set analysis

01Nikita — Thu, 21 May 2020 07:48:11 GMT

Hi Everyone,

I have been working on application i m stuck in writing set analysis formula can anyone help

Set analysis if we want to calculate average price of product in current month where there are 100 types of products which are sales to different customer in different month with different discount

i have tried multiple ways but unable to get desired output

Re: Set analysis

agigliotti — Thu, 21 May 2020 08:01:40 GMT

Hi,
could you elaborate a little bit more?
what's your actual result?
what's your desired result?

Re: Set analysis

01Nikita — Thu, 21 May 2020 09:30:42 GMT

desired output is selling price of product in current month

Re: Set analysis

jonathandienst — Thu, 21 May 2020 10:02:09 GMT

You need to provide a lot more information if you want useful help. A mockup of your expected output and some sample data in the same structure as your QV document would go a long way.

Re: Set analysis

Brett_Bleess — Tue, 16 Jun 2020 17:05:41 GMT

Lots of prior posts in the Community on Set Analysis, you can also check out the following Design Blog posts:

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

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

About the best I can offer given what you have provided.

Regards,
Brett