Issue with set analysis formula

[#1]

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.

[mike_garcia]

Maybe this will do it:

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

Hope that helps.

Mike.

[#3]

have u tried

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

[#4]

and did it work or what?

[#5]

Blaze,

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

[#6]

um...try this

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

maybe that will help...

[#7]

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