topic Re: Mapping in QlikView

Mapping

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

i m trying to do applymap to change the text in my table

My script below:

MapName:

Mapping

LOAD * inline[

ActualName, RedefinedName

Sales Records, Sales

Credits Records, Credits

];

TableA:

Load ...,

ApplyMap('MapName',[Record Name]) as [Record Name]

from...qvd;

when i try this the text has not changed.

i cant find what is wrong here.

can anyone please help me.

Re: Mapping

chetansehgal — Thu, 08 Sep 2016 12:08:04 GMT

Can you please share the data or sample qvw.?

Re: Mapping

Chanty4u — Thu, 08 Sep 2016 12:09:05 GMT

Add resident . am not sure

like sample

Map_Price: //Mapping Table

Mapping LOAD * INLINE [

Category, Price

Adult, 10

Child, 5

Student, 6

Senior, 6

LoyalMember, 5

];

Tickets:

LOAD * INLINE [

Name, Class

Ann, Student

David, Adult

Sara, Senior

Keith, Child

Tom, Adult

Dave, Student

Sam, Adult

Monica, LoyalMember

Ethan, Student

Rose, Child

];

Price:

Load

Name,

Class,

ApplyMap('Map_Price',Class) as TicketPrice //Here we use applymap to look up for the ticket prices

Resident

Tickets;

Drop Table Tickets;

Re: Mapping

Chanty4u — Thu, 08 Sep 2016 12:11:25 GMT

chk this

Re: Mapping

Clever_Anjos — Thu, 08 Sep 2016 12:26:49 GMT

Try this

ApplyMap('MapName',Replace(Trim([Record Name]),' ',' )) as [Record Name] // trimming and removing double spaces

Re: Mapping

sunny_talwar — Thu, 08 Sep 2016 12:49:36 GMT

Can you share a list box where we can see Record Name from your qvd? I think there might be name mismatch between the mapping table and Record Name field