8 Replies Latest reply: Aug 14, 2018 11:54 AM by Alba Del Valle López-Lillo

# Make sum product

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?

Regards,

• ###### Re: Make sum product

could you provide a sample app with mock data ?

i guess your question is not clear.

• ###### Re: Make sum product

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:

• ###### Re: Make sum product

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

• ###### Re: Make sum product

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)

• ###### Re: Make sum product

Hi,

could u explain urself better?

I cant understand it well.

ty so much

• ###### Re: Make sum product

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.

• ###### Re: Make sum product

Hi,

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