Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
sanjujeeboy
New Contributor II

How to map?

how to get pie chart with 2 measures

 

2 Replies
jyothish8807
Honored Contributor II

Re: How to map?

Try this:

A:

Load

MAG,

Revenue,

Unit

from <>;

B:

Load

[MAG Main] as MAG

'MAG Main' as NewField

from <>;

Now In UI make a list box add "NewField" in it.

Create a straight chart :

Dim: MAG

Exp1: Sum(Revenue)

Exp2: Sum(Unit)

 

Now if you dont select anything, you will get all the values, but when you select "MAG Main" from drop down of "Newfield" you will get only "hybrid,grooming accessories"

Best Regards,
KC
gf
Contributor II

Re: How to map?

Map always requires a key value pair. I don't think it is possible to map more than one value.

For example:

If you have a mapping table like:

Key    Value

1          A

2          B

3         C

and another table like 

ShowLetter:

RowNum     Number

1                      1

2                      2

3                      2

 

Table ShowLetter would look like:

RowNum     Number

1                      A

2                     B

3                     B

 

How to declare a table as mapping table:

Just write

MapNumber:

Mapping LOAD Key as KEY, Value as VALUE FROM.....

 

And in the table where you want to map

LOAD ApplyMap('MapNumber',vKey) FROM....