Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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:

Captura.PNG

How would you do this in QlikSense?

Thanks in advance.

Regards,

8 Replies
Highlighted
Partner
Partner

Re: Make sum product

could you provide a sample app with mock data ?

i guess your question is not clear.

Highlighted
Contributor II
Contributor II

Re: Make sum product

Good morning


I want to make, the following formula sum product, the following example, the result is marked in yellow.Captura1.PNG

I want to make I want to do the following:

Captura.PNG

Highlighted
Creator II
Creator II

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

Highlighted

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)

Highlighted

Re: Make sum product

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor II
Contributor II

Re: Make sum product

Hi,

Ty for answer me.

could u explain urself better?

I cant understand it well.

ty so much

Highlighted

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.

Highlighted
Contributor II
Contributor II

Re: Make sum product

Hi,

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