Make sum product
I'm trying to do what in excel would be a weighting in Qlik Sense.
My question is, how would you do it, I give you an example:
To take out what is in yellow, we have made the following formulation:
How would you do this in QlikSense?
Thanks in advance.
Do you know how sumproduct works in excel?
If I am correct it will just multiplies the each element with corresponding position element in the next set and add everything.
Like a weighted sum.
It is possible in Qlik.
Sum(Total (Z*Y*X))/Sum(Total (Y*X))
May be try like this:
I think, RangeSum() can resolve your solution https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/RangeFunctions/rang...