Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to map?

how to get pie chart with 2 measures

 

2 Replies
Highlighted
Master II
Master 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
Highlighted
Creator III
Creator III

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