Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Map commend for Flag hot selling items

Hi All

Now i manually tick on my excel file column Hot = 1 for those items is hot selling.

I want to replace by load script , using map command for doing this .

So i create a map script :-

HotMap:

mapping LOAD * INLINE [

OldCode,NewCode

TS1070,1

TS1070i,1

TS1100,1

TS1100i,1

];

In my Tab = TS , i add below script :-

  ApplyMap('HOTMAP', Model,'','1') AS HOT_MAP,

I get error msg , parameter need 2 to 3....

1 Solution

Accepted Solutions
MVP
MVP

Re: Map commend for Flag hot selling items

Try removing extra single quotes like:

ApplyMap('HOTMAP', Model,'1') AS HOT_MAP,

2 Replies
MVP
MVP

Re: Map commend for Flag hot selling items

Try removing extra single quotes like:

ApplyMap('HOTMAP', Model,'1') AS HOT_MAP,

Not applicable

Re: Map commend for Flag hot selling items

Thank Tres

Community Browser