Discussion board where members can get started with QlikView.
how to get pie chart with 2 measures
[MAG Main] as MAG
'MAG Main' as NewField
Now In UI make a list box add "NewField" in it.
Create a straight chart :
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"
Map always requires a key value pair. I don't think it is possible to map more than one value.
If you have a mapping table like:
and another table like
Table ShowLetter would look like:
How to declare a table as mapping table:
Mapping LOAD Key as KEY, Value as VALUE FROM.....
And in the table where you want to map
LOAD ApplyMap('MapNumber',vKey) FROM....