Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe this will do it:
=Sum({<FromCurrency={'$(vCURR)'}, QtyInvoice = {"=Sum(UnitCosts)>4"}>} QtyInvoice)
Hope that helps.
Mike.
have u tried
sum({<FromCurrency={'$(vCURR)'}, UnitCosts={>"4"}>} QtyInvoice)
and did it work or what?
Blaze,
Unfortunately not. When I move the position of the quotes a null value is returned.
um...try this
sum(({<FromCurrency={'$(vCURR)'}, UnitCosts={<'4'}>}-1) QtyInvoice)
maybe that will help...
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