topic Re: create new feild in QlikView

create new feild

tenyeapen — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: create new feild

tresB — Mon, 19 Aug 2019 07:48:24 GMT

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.

Re: create new feild

Arthur_Fong — Mon, 19 Aug 2019 08:10:34 GMT

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

Re: create new feild

tenyeapen — Mon, 19 Aug 2019 09:23:48 GMT

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

Re: create new feild

smilingjohn — Mon, 19 Aug 2019 11:35:11 GMT

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

Re: create new feild

tenyeapen — Tue, 20 Aug 2019 07:59:48 GMT

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',

Re: create new feild

tenyeapen — Tue, 20 Aug 2019 08:07:34 GMT

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',

Re: create new feild

tenyeapen — Tue, 20 Aug 2019 08:09:14 GMT

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],('Archana Iyer','Carl Wooding','Malika Lala'),'Marine',

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

Re: create new feild

Frank_Hartmann — Tue, 20 Aug 2019 08:20:52 GMT

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'