Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sanjujeeboy
Creator
Creator

How to map?

how to get pie chart with 2 measures

 

Labels (2)
2 Replies
jyothish8807
Master II
Master II

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
Creator III
Creator III

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....