6 Replies Latest reply: Jul 15, 2010 6:09 AM by Ravi Achaliya RSS

    Issue with set analysis formula

      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.