Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
01Nikita
Partner - Contributor III
Partner - Contributor III

Set analysis

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

 

4 Replies
agigliotti
Partner - Champion
Partner - Champion

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

01Nikita
Partner - Contributor III
Partner - Contributor III
Author

desired output is selling price of product in current month

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Brett_Bleess
Former Employee
Former Employee

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

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.