create new feild

[tenyeapen]

I have a set of client names, I want to show them as a division wise on qlikview. Please help.

For example, A,B,C,D,E,F,G,H are the clients

I want show them as division wise like D1 , D2, D3. where D1 contains the client A,D,E. D2 contains B,C. etc

[tresesco]

If this list, i.e. - number of clients is big, try using applymap() in the script, else for few clients you could try with pick(match(.. expression.

[Arthur_Fong]

if the list isn't that big and can be manually mapped,

try the script below:

load 

if(match(clients,'A','D','E'),'D1',

if(match(client,'B','C'),'D2',

...

...)) as Division

resident <Table Name>.

Thanks and regards,

Arthur Fong

[tenyeapen]

I'm a very basic beginner in this. so can u please describe where to update this code? and which option I should select.

[smilingjohn]

Hi,

You are trying to say that you need a new field which should contain the buckets(Groups) of the clients, 

This can be achieved in the edit script using match function as shown below . 

Load your data in the edit script  and use the field which has A,B,C.. clients , I believe the field name to be client 

if(wildmatch( Client,'A','B','C')'D1',

if(wildmatch(client,'B','C'),'D2',

if(wildmatch(clients,'G','I','E'),'D3))) as Bucket_Client',

Regards

[tenyeapen]

HI



I tried that and getting below error.



Error in expression:

')' expected

LOAD

if(wildmatch([ACCOUNT EXECUTIVE],('Gabriel Gracias','Geetha Ravindran','Jiffy Regner','Prasanna Moses','PRASHANT JHA','Puja Kapoor','Tanveer Bondre','Thejas Nair','Yohan Jayawardene'),'CCP',

if(WildMatch([ACCOUNT EXECUTIVE],('Anindita Khanna','Azza El Hag','Bilal Javaid','Emil Chandy','Fatma Al Suwaidi','James Miller','Joyce Dsouza','Karan Chawla','Leah Fernandez','Mahmoud Saied-Mmm','Mostafa Nab','Nairoz Bashir','Philip Bell','Philip Bell','Rachel Dayaldas','Rafzan Jamsabe','Rahul Srivastava','Roula Assi','Roula Assi-Eb','Salini Jobinse','Sandhya Ramachandran','Shyamdas Koylerian','Sudeshna Sen','Sudish Kumar','Sumavathi Kotian','Tariq Azad'),'EH&B',

if(WildMatch([ACCOUNT EXECUTIVE],('Archana Iyer','Carl Wooding','Malika Lala'),'Marine',

if(WildMatch([ACCOUNT EXECUTIVE],('Aisha Al Ali','Ali Saeidi','Bradely James Simpson','Coleen Watt','Edward Sheppard','Elizabeth A Mascarenhas','Fouad DiabMaalouf','Harsh Dutia','Hassan Ashtari','Hema Ganga','Imran Muhammad','Jayashree Warrier','Leah Villaroman','MARY GRACE GALLANO','Nazia Javed','Ni**bleep**a Gupta','Preeti Baruah','Raynah Patrao','Reem Elshereye','Roann Alaras','Sanjay Kondur','Sara Hamad','U Samarasena','Vikram Prabhakar'),'RMP-MCS',

if(WildMatch([ACCOUNT EXECUTIVE],('Guillaume Gaudry','PRABHAT DHOUNDIYAL','Vinu Sarah Binoy'),'Trade Credit'))))) as 'Department',

[tenyeapen]

hi 

I tried that and got below error.

Error in expression:

')' expected

LOAD

if(wildmatch([ACCOUNT EXECUTIVE],('Gabriel Gracias','Geetha Ravindran','Jiffy Regner','Prasanna Moses','PRASHANT JHA','Puja Kapoor','Tanveer Bondre','Thejas Nair','Yohan Jayawardene'),'CCP',

if(WildMatch([ACCOUNT EXECUTIVE],('Anindita Khanna','Azza El Hag','Bilal Javaid','Emil Chandy','Fatma Al Suwaidi','James Miller','Joyce Dsouza','Karan Chawla','Leah Fernandez','Mahmoud Saied-Mmm','Mostafa Nab','Nairoz Bashir','Philip  Bell','Philip Bell','Rachel Dayaldas','Rafzan Jamsabe','Rahul Srivastava','Roula Assi','Roula Assi-Eb','Salini Jobinse','Sandhya Ramachandran','Shyamdas Koylerian','Sudeshna Sen','Sudish Kumar','Sumavathi Kotian','Tariq Azad'),'EH&B',

if(WildMatch([ACCOUNT EXECUTIVE],('Archana Iyer','Carl Wooding','Malika Lala'),'Marine',

if(WildMatch([ACCOUNT EXECUTIVE],('Aisha Al Ali','Ali Saeidi','Bradely James Simpson','Coleen Watt','Edward Sheppard','Elizabeth A Mascarenhas','Fouad DiabMaalouf','Harsh Dutia','Hassan Ashtari','Hema Ganga','Imran Muhammad','Jayashree Warrier','Leah Villaroman','MARY GRACE GALLANO','Nazia Javed','Ni**bleep**a Gupta','Preeti Baruah','Raynah Patrao','Reem Elshereye','Roann Alaras','Sanjay Kondur','Sara Hamad','U Samarasena','Vikram Prabhakar'),'RMP-MCS',

if(WildMatch([ACCOUNT EXECUTIVE],('Guillaume Gaudry','PRABHAT DHOUNDIYAL','Vinu Sarah Binoy'),'Trade Credit'))))) as 'Department',

[tenyeapen]

I tried and got below error, please help me...

Error in expression:

')' expected

LOAD

if(wildmatch([ACCOUNT EXECUTIVE],('Gabriel Gracias','Geetha Ravindran','Jiffy Regner','Prasanna Moses','PRASHANT JHA','Puja Kapoor','Tanveer Bondre','Thejas Nair','Yohan Jayawardene'),'CCP',

if(WildMatch([ACCOUNT EXECUTIVE],('Anindita Khanna','Azza El Hag','Bilal Javaid','Emil Chandy','Fatma Al Suwaidi','James Miller','Joyce Dsouza','Karan Chawla','Leah Fernandez','Mahmoud Saied-Mmm','Mostafa Nab','Nairoz Bashir','Philip  Bell','Philip Bell','Rachel Dayaldas','Rafzan Jamsabe','Rahul Srivastava','Roula Assi','Roula Assi-Eb','Salini Jobinse','Sandhya Ramachandran','Shyamdas Koylerian','Sudeshna Sen','Sudish Kumar','Sumavathi Kotian','Tariq Azad'),'EH&B',

if(WildMatch([ACCOUNT EXECUTIVE],('Archana Iyer','Carl Wooding','Malika Lala'),'Marine',

if(WildMatch([ACCOUNT EXECUTIVE],('Aisha Al Ali','Ali Saeidi','Bradely James Simpson','Coleen Watt','Edward Sheppard','Elizabeth A Mascarenhas','Fouad DiabMaalouf','Harsh Dutia','Hassan Ashtari','Hema Ganga','Imran Muhammad','Jayashree Warrier','Leah Villaroman','MARY GRACE GALLANO','Nazia Javed','Ni**bleep**a Gupta','Preeti Baruah','Raynah Patrao','Reem Elshereye','Roann Alaras','Sanjay Kondur','Sara Hamad','U Samarasena','Vikram Prabhakar'),'RMP-MCS',

if(WildMatch([ACCOUNT EXECUTIVE],('Guillaume Gaudry','PRABHAT DHOUNDIYAL','Vinu Sarah Binoy'),'Trade Credit'))))) as 'Department',

[Frank_Hartmann · Accepted solution]

maybe this:

if(wildmatch([ACCOUNT EXECUTIVE],'Gabriel Gracias,Geetha Ravindran','Jiffy Regner','Prasanna Moses','PRASHANT JHA','Puja Kapoor','Tanveer Bondre','Thejas Nair','Yohan Jayawardene'),'CCP',

if(WildMatch([ACCOUNT EXECUTIVE],'Anindita Khanna','Azza El Hag','Bilal Javaid','Emil Chandy','Fatma Al Suwaidi','James Miller','Joyce Dsouza','Karan Chawla','Leah Fernandez','Mahmoud Saied-Mmm','Mostafa Nab','Nairoz Bashir','Philip  Bell','Philip Bell','Rachel Dayaldas','Rafzan Jamsabe','Rahul Srivastava','Roula Assi','Roula Assi-Eb','Salini Jobinse','Sandhya Ramachandran','Shyamdas Koylerian','Sudeshna Sen','Sudish Kumar','Sumavathi Kotian','Tariq Azad'),'EH&B',

if(WildMatch([ACCOUNT EXECUTIVE],'Archana Iyer','Carl Wooding','Malika Lala'),'Marine',

if(WildMatch([ACCOUNT EXECUTIVE],'Aisha Al Ali','Ali Saeidi','Bradely James Simpson','Coleen Watt','Edward Sheppard','Elizabeth A Mascarenhas','Fouad DiabMaalouf','Harsh Dutia','Hassan Ashtari','Hema Ganga','Imran Muhammad','Jayashree Warrier','Leah Villaroman','MARY GRACE GALLANO','Nazia Javed','Ni**bleep**a Gupta','Preeti Baruah','Raynah Patrao','Reem Elshereye','Roann Alaras','Sanjay Kondur','Sara Hamad','U Samarasena','Vikram Prabhakar'),'RMP-MCS',

if(WildMatch([ACCOUNT EXECUTIVE],'Guillaume Gaudry','PRABHAT DHOUNDIYAL','Vinu Sarah Binoy'),'Trade Credit'))))) as 'Department'