topic Query in Mapping in QlikView

Query in Mapping

Fri, 04 Jun 2010 07:26:34 GMT

Hi All,

Here I have enclosed my Inline table.First column will be the Region.Second Column will be the short form City.And the third column will be the Coulumn should be visible for End user.I want to do this using in 'MAPPING' Is it possible.If it is how.Please let me know the same

Map:
LOAD * INLINE [
Region, City,NewCity
South, Blr,BANGALORE
North, Del,DELHI
East, Raj,RAJSTHAN
West, Cal,CALCUTTA
];

Note: I shoud not use use 'IF'

Thanks & Regards

Jai

Query in Mapping

sparur — Fri, 04 Jun 2010 08:05:58 GMT

hello Jai.

You can create a table City:

CityTable:

LOAD * INLINE [
City,CityFull
Blr,BANGALORE
Del,DELHI
Raj,RAJSTHAN
Cal,CALCUTTA
];

and create a map table by region:

MAP_Region_City:

MAPPING LOAD * INLINE [
Region, City
South, Blr
North, Del
East, Raj
West, Cal
];

and then use it map in your transactional table:

FactTable:

LOAD ...

Region,

ApplyMap('MAP_Region_City', Region, 'N/A') as City

FROM ....

And in the layout you can use a listbox for field CityFull.