4 Replies Latest reply: Oct 29, 2014 2:56 PM by Ashfaq Mohammed RSS

    Question on Charts and Legends

      I'm new to Qlikview and have a question

       

      Let's say I have a Table A with this data:

       

      Item         Category_Code

      Apple                1

      Banana             1

      Tomato             2

      Carrot               2

      Sponge             3

      Trash Bags       3

       

      and I have a Table B with Category Codes

       

      Category_Code          Name

            1                         Fruits

            2                         Vegetables

            3                         House Products

       

      Assuming that I have load both tables, how do I create a Pie Chart for Table A and utilizing Table B for the Legend.    I've been able to create a Pie Chart using Table A but the Legend comes out using the Category Code which is not usable.