topic Issue with set analysis formula in QlikView

Issue with set analysis formula

Wed, 14 Jul 2010 15:17:59 GMT

I have a table that contains a column of unit costs and unit quantities. I need to create a variable in a chart which adds the total invoice quantities where the unit cost is > 4. I am using the following formula however the UnitCosts={"<>4"} portion of the formula is being ignored. I keep receiving the sum of all quantities.

sum({<FromCurrency={'$(vCURR)'}, UnitCosts={"<>4"}>} QtyInvoice)

I am a qlikview novice. Any help is greatly appreciated.

Issue with set analysis formula

mike_garcia — Wed, 14 Jul 2010 15:50:23 GMT

Maybe this will do it:

=Sum({<FromCurrency={'$(vCURR)'}, QtyInvoice = {"=Sum(UnitCosts)>4"}>} QtyInvoice)

Hope that helps.

Mike.

Issue with set analysis formula

Wed, 14 Jul 2010 15:51:25 GMT

have u tried

sum({<FromCurrency={'$(vCURR)'}, UnitCosts={>"4"}>} QtyInvoice)

Issue with set analysis formula

Thu, 15 Jul 2010 08:16:49 GMT

and did it work or what?

Issue with set analysis formula

Thu, 15 Jul 2010 09:42:39 GMT

Blaze,

Unfortunately not. When I move the position of the quotes a null value is returned.

Issue with set analysis formula

Thu, 15 Jul 2010 09:48:45 GMT

um...try this

sum(({<FromCurrency={'$(vCURR)'}, UnitCosts={<'4'}>}-1) QtyInvoice)

maybe that will help...

Issue with set analysis formula

Thu, 15 Jul 2010 10:09:59 GMT

Hi Paul,

Plz refer to attachment.

Use SET Analysis instead of variable.

Formula will be

Sum

({<Cost = {">4"}>}Qty )

Let me know if there is difficulty.

Sincere Regards,

Happy Thoughts