topic Re: Question on Charts and Legends in QlikView

Question on Charts and Legends

Wed, 29 Oct 2014 17:46:57 GMT

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.

Re: Question on Charts and Legends

maxgro — Wed, 29 Oct 2014 17:53:26 GMT

use Name instead of Category_Code for dimension

example

dimension Name

expression count(Item)

Re: Question on Charts and Legends

ashfaq_haseeb — Wed, 29 Oct 2014 17:57:01 GMT

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.

Re: Question on Charts and Legends

Wed, 29 Oct 2014 18:26:51 GMT

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

Re: Question on Charts and Legends

ashfaq_haseeb — Wed, 29 Oct 2014 18:56:52 GMT

Hi,

Can you please close this thread by selection appropriate answers.

REGARDS

ASHFAQ