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.