Question on Charts and Legends

[#1]

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.

[maxgro · Accepted solution]

use Name instead of Category_Code for dimension

example

dimension     Name

expression     count(Item)

[ashfaq_haseeb]

Hi,

Use below code in your New Qlik Document

Load * Inline
[
 Item,Category_Code
Apple,1
Banana,1
Tomato,2
Carrot,2
Sponge,3
Trash Bags,3
];

Load * Inline
[
Category_Code,Name
      1,Fruits
      2,Vegetables
      3,House Products
];

Create New Chart --> Select Pie -->

Dimension:

Name

Expression:

=count(Item)

Have a look at attached application too.

[#4]

Thanks for such a fast responses...It has corrected my problem (and advanced my understanding of the product).

[ashfaq_haseeb]

Hi,

Can you please close this thread by selection appropriate answers.

REGARDS

ASHFAQ