Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
could you elaborate a little bit more?
what's your actual result?
what's your desired result?
desired output is selling price of product in current month
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.
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