Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
coloful_architect
Creator II
Creator II

weighted avg and aggr

Hi guys,

I have a table with competitors and own company's sales units as well as prices.

Trying to use aggar function to calculate the competitors 's sales units.

as you see at the screenshot, for some reason , I fail to get expected number. aggar return me null

what I am using is 

 

Sum({<Supplier={'competitor'},Month = {"$(=Max({1}Month))"}>} [QTY Each])

*
(aggr(avg({<Month = {"$(=Max(Month))"},[Supplier]=-{'Competitor'}>} [Competitor Price]),[Product level])

 

anything I miss? 

 

thanks

coloful_architect_1-1631571713916.png

coloful_architect_3-1631571974340.png

 

 

 

0 Replies