Make sum product

[alba_delvalle]

Make sum product

Good afternoon,

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.

Regards,

[agigliotti]

could you provide a sample app with mock data ?

i guess your question is not clear.

[alba_delvalle]

Good morning

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:

[rangam_s]

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))

[BalaBhaskar_Qlik]

May be try like this:

Sum({<Project={"P3","P4"},Status={"Pending","In Process"},Col1={"a","B","C"}>}QTY)

/

                             Sum({<Status={"Pending","In Process"},Col1={"a","B","C"}>}QTY)

[Anil_Babu_Samineni]

I think, RangeSum() can resolve your solution https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/RangeFunctions/rang...

[alba_delvalle]

Hi,

Ty for answer me.

could u explain urself better?

I cant understand it well.

ty so much

[BalaBhaskar_Qlik]

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.

[alba_delvalle]

Hi,

Thank you very much for your help, I got it !!!