Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Need Your Help Community with Code that won't work

Have to 2 main files coming from SFDC into Qlikview (Activity and Owner).  Need to add a Sales Hierarchy to the Owner file once the table is in qv, but my qv person can't get the code to work.  Any thoughts? Comments?

SalesEngine:
Load
UserRoleId,
if(UserRole = '.ISR' OR UserRole = '.ISR Manager - Team 2' OR UserRole = '.VP Inside' OR UserRole= '.ISR Team 1' OR UserRole = '.ISR Team 2' OR UserRole= '.ISR Team 3' OR UserRole= '.ISR Team 4' OR UserRole= '.ISR Team 5' OR UserRole= '.ISR Team 6',  'ISR',
if(UserRole = '.ISR India/APAC' OR UserRole = 'Head of India/APAC', 'India/APAC',
if(UserRole = 'ISR EMEA' OR UserRole = 'ISR Manager EMEA', 'ISR EMEA',
if(UserRole = '.Account Manager' OR UserRole = '.Director Account Management', 'Account Managers',
if(UserRole = '.BDA' OR UserRole = '.BDA Manager', 'BDA',
If(UserRole= '.RSM Federal' OR UserRole= '.RSM Federal II', 'RSM - Fed',
if(UserRole = '.RSM Outside' OR UserRole = '.VP Outside & International', 'RSM - US',
if(UserRole = '.RSD International' OR UserRole = '.RSM International', 'RSM - EMEA','Other')))))))) as [Sales Engine Group]

FROM $(vQVDPath)UserRole_incr.qvd (qvd);

3 Replies
alexandros17
Not applicable

Re: Need Your Help Community with Code that won't work

Check if  LOAD * FROM $(vQVDPath)UserRole_incr.qvd (qvd); works


Your expression is correct so the problem may be in your path variable ...

Not applicable

Re: Need Your Help Community with Code that won't work

Appreciate the feedback. I will have her check that.

Marc

its_anandrjs
Not applicable

Re: Need Your Help Community with Code that won't work

Try the same script with the Match function

SalesEngine:

Load

UserRoleId,

if(Match(UserRole = '.ISR','.ISR Manager - Team 2','.VP Inside','.ISR Team 1','.ISR Team 2','.ISR Team 3','.ISR Team 4','.ISR Team 5','.ISR Team 6'),'ISR',

if(Match(UserRole = '.ISR India/APAC','Head of India/APAC'),'India/APAC',

if(Match(UserRole = 'ISR EMEA','ISR Manager EMEA'),'ISR EMEA',

if(Match(UserRole = '.Account Manager','.Director Account Management'), 'Account Managers',

if(Match(UserRole = '.BDA','.BDA Manager'), 'BDA',

If(Match(UserRole= '.RSM Federal','.RSM Federal II'), 'RSM - Fed',

if(Match(UserRole = '.RSM Outside','.VP Outside & International'), 'RSM - US',

if(Match(UserRole = '.RSD International','.RSM International'), 'RSM - EMEA','Other')))))))) as [Sales Engine Group]

FROM $(vQVDPath)UserRole_incr.qvd (qvd);