topic Re: Set Analysis Pricing in App Development

Set Analysis Pricing

alexsid-qlik — Thu, 13 Dec 2018 12:23:00 GMT

Dear Community,

I am struggling with my calculation. What I have is a list of Options and their respective price. Also I know how many of them were sold. So I want to cumulate this Sales.

I tried this approach : Sum({$<[Price] -= '0'>} [Price]*Quantity)

But it doesn't work properly! I attached an excel as an example.

I would be happy for your help.

Regards, Alex

Re: Set Analysis Pricing

sunny_talwar — Thu, 13 Dec 2018 12:24:06 GMT

Try this

Sum({$<[Price] -= {'0'}>} [Price]*Quantity)

Re: Set Analysis Pricing

Anil_Babu_Samineni — Thu, 13 Dec 2018 12:26:48 GMT

Try this as well, Make sure whether you have applied correct field

Sum(If(Price <> '0', Price*Quantity))

Sum({<Price = {"=Sum(Price)<>0"}>} Price*Quantity)

Re: Set Analysis Pricing

alexsid-qlik — Thu, 13 Dec 2018 12:33:29 GMT

Thank you @sunny_talwar and @Anil_Babu_Samineni!

Both solutions work excellent for me.

Re: Set Analysis Pricing

alexsid-qlik — Tue, 08 Jan 2019 12:48:55 GMT

Hi,

the number seemed a little bit too high actually.

So I exported my table to Excel. And when I sum up there I get a much lower number. How can that be?

Would be thankful for help.

Re: Set Analysis Pricing

sunny_talwar — Tue, 08 Jan 2019 12:50:47 GMT

Would you be able to share a sample to show the issue?

Re: Set Analysis Pricing

alexsid-qlik — Tue, 08 Jan 2019 13:00:11 GMT

I cant share my initial data because it is sensitive. And when I simplify the data it works. So there must me something wrong in my data. I am sure the formula works right.

Re: Set Analysis Pricing

sunny_talwar — Tue, 08 Jan 2019 13:03:51 GMT

@alexsid-qlik wrote:
I cant share my initial data because it is sensitive. And when I simplify the data it works. So there must me something wrong in my data. I am sure the formula works right.

In that case, I am not really sure how to help you... I mean I need to see something before I can see what might be going on.

Re: Set Analysis Pricing

alexsid-qlik — Tue, 08 Jan 2019 13:10:26 GMT

ok i found my mistake. I had a wrong Where statement in my load script.

Re: Set Analysis Pricing

sunny_talwar — Tue, 08 Jan 2019 13:13:00 GMT

Great 🙂