topic Re: How to map? in QlikView

How to map?

sanjujeeboy — Sat, 16 Nov 2024 03:54:13 GMT

how to get pie chart with 2 measures

Re: How to map?

jyothish8807 — Wed, 10 Apr 2019 07:59:33 GMT

Try this:

Load

MAG,

Revenue,

Unit

from <>;

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"

Re: How to map?

gf — Wed, 10 Apr 2019 08:01:28 GMT

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