6 Replies Latest reply: Sep 12, 2012 1:27 PM by Lance James RSS

    Best way to find % of Items Priced in a certain Group

      Okay here I go.  I have many items with many different prices.  I want to first group those items priced into increments of 50 Cents.  For example

       

      Item     Price    

      A          .75    

      B          .95

      C          1.25

      D          1.49

       

      I want QlikView to give me this, i set the paraments that Price Group A is anything price between 50 cents and $1, and Price Group B is anything priced between $1.01 and $1.50

      Item     Price     Price Group

      A          .75          A

      B          .95          A

      C          1.25        B

      D          1.49        B

       

      Many Thanks