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.
could you provide a sample app with mock data ?
i guess your question is not clear.
I want to make, the following formula sum product, the following example, the result is marked in yellow.
I want to make I want to do the following:
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:
Ty for answer me.
could u explain urself better?
I cant understand it well.
ty so much
Hence you're doing multiple array selection in excel, the same i tried with using of Set analysis by specifying each field with example values.
I think, RangeSum() can resolve your solution https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/RangeFunctions/rangesum.htm
Thank you very much for your help, I got it !!!
Retrieving data ...