Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Apply Map Prb

Dear All,

Plz find the attachment...

How i can solve this problem...

Plzreply

4 Replies
amit_saini
Master III
Master III

Rahul,

Go through this attachment.

Thanks,

AS

er_mohit
Master II
Master II

write applymap this way

ApplyMap('Table1',C) as B

before table closed write

where condition  like

Data:

LOAD C,

ApplyMap('Table1',C) as B,

     D,

     E

FROM

C:\Users\Administrator\Desktop\Applymap.xlsx

(ooxml, embedded labels, table is Sheet2) where 1=1;

Not applicable
Author

Thanks mohit

But what about Table1 where 1=AA and 2=VV...??

Is Applymap show only first mapping records..?

Not applicable
Author

Hi Rahul,

Hope this will solve your issue...

Data:

LOAD

     C,

     D,

     E

FROM

[..\Desktop\Applymap.xlsx]

(ooxml, embedded labels, table is Sheet2);

join(Data)

LOAD C,

  B

FROM

[..\Desktop\Applymap.xlsx]

(ooxml, embedded labels, table is Sheet1);