Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

reply on answer

Applied the said formula, but an error comes in loading the data, Look forward to resolve this!

LOAD CLASS_CODE,

     Pick(Match(CLASS_CODE,'MC','M3','M4')+1,'NONMOTOR','MOTOR','MOTOR','MOTOR',

     PREMIUM

FROM

D:\CLASS.xlsx

(ooxml, embedded labels, table is Sheet1);

1 Solution

Accepted Solutions
felipedl
Partner - Specialist III
Partner - Specialist III

Hi Neville,

You're missing a parenthesis on the Pick statement

Like this

LOAD CLASS_CODE,

     Pick(Match(CLASS_CODE,'MC','M3','M4')+1,'NONMOTOR','MOTOR','MOTOR','MOTOR') as T,

     PREMIUM

FROM

D:\CLASS.xlsx

(ooxml, embedded labels, table is Plan2);

View solution in original post

1 Reply
felipedl
Partner - Specialist III
Partner - Specialist III

Hi Neville,

You're missing a parenthesis on the Pick statement

Like this

LOAD CLASS_CODE,

     Pick(Match(CLASS_CODE,'MC','M3','M4')+1,'NONMOTOR','MOTOR','MOTOR','MOTOR') as T,

     PREMIUM

FROM

D:\CLASS.xlsx

(ooxml, embedded labels, table is Plan2);