Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'
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.
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
I'm a very basic beginner in this. so can u please describe where to update this code? and which option I should select.
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
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',
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',
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'