Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

desired output is selling price of product in current month

Highlighted

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
Highlighted
Digital Support
Digital Support

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.