topic Re: Summing a calculated multi part Expression in QlikView

Summing a calculated multi part Expression

suepenick — Mon, 08 Jul 2013 22:31:42 GMT

When I use this expression it works

StdCost * (Sum(if (SaleType='Pontoons', QtyShipped)))

but when I want to Total it, it will not work

SUM ( StdCost * (Sum(if (SaleType='Pontoons', QtyShipped))))

any Ideas?

Re: Summing a calculated multi part Expression

Mon, 08 Jul 2013 22:44:35 GMT

test the next just add sum the first expression:

sum(StdCost) * (Sum(if (SaleType='Pontoons', QtyShipped)))

regards!!!!

Re: Summing a calculated multi part Expression

Mon, 08 Jul 2013 22:48:14 GMT

Or this way

Sum (if (SaleType='Pontoons', QtyShipped*StdCost))

Re: Summing a calculated multi part Expression

Sokkorn — Tue, 09 Jul 2013 00:45:12 GMT

Hi Penick,

Did you try below script yet?

Sum({$<SaleType = {'Pontoons'}>} StdCost*QtyShipped)

Regards,

Sokkorn

Re: Summing a calculated multi part Expression

suepenick — Tue, 09 Jul 2013 12:19:42 GMT

This one made the total go into the billions.

Re: Summing a calculated multi part Expression

suepenick — Tue, 09 Jul 2013 12:21:17 GMT

Thanks! You can't even know how many different ways I tried to make this work. and then I look at your solution and want to slap myself on the forehead! Thanks so much