topic Re: Help with creating new dimension using like/not like in QlikView

Help with creating new dimension using like/not like

chiso_chiso — Tue, 22 Sep 2015 12:49:43 GMT

Guru,

I have a script as below;

if ( [Service] Like '*Admin*', 'Admin',

if ( [Service] Like '*Complaint*', 'Complaint',

if ( [Service] Like '*Claim*', 'Claim',

if ( [Service]Like '*Sale*', 'Sale',

if (not [Service] like ('*Sale*','*Admin*','*Complaint*','*Claim*')),'Other')))) as ServiceType

Apparently the 'Other' is not being created. Kindly assist

Re: Help with creating new dimension using like/not like

swuehl — Tue, 22 Sep 2015 12:54:46 GMT

Try

if ( [Service] Like '*Admin*', 'Admin',

if ( [Service] Like '*Complaint*', 'Complaint',

if ( [Service] Like '*Claim*', 'Claim',

if ( [Service] Like '*Sale*', 'Sale', 'Other')))) as ServiceType

Re: Help with creating new dimension using like/not like

sunny_talwar — Tue, 22 Sep 2015 12:55:06 GMT

Try this may be:

If([Service] Like '*Admin*', 'Admin', If([Service] Like '*Complaint*', 'Complaint', If([Service] Like '*Claim*', 'Claim', If([Service] Like '*Sale*', 'Sale','Other')))) as ServiceType

Re: Help with creating new dimension using like/not like

chiso_chiso — Tue, 22 Sep 2015 13:01:40 GMT

Thank you so much. It worked

Re: Help with creating new dimension using like/not like

sasiparupudi1 — Tue, 22 Sep 2015 13:05:19 GMT

= if ( lower([Service]) Like '*admin*', 'Admin', if ( lower([Service]) Like '*complaint*', 'Complaint', if ( lower([Service]) Like '*claim*', 'Claim', if ( lower([Service]) Like '*sale*', 'Sale', 'Other')))) as ServiceType

Re: Help with creating new dimension using like/not like

sasiparupudi1 — Tue, 22 Sep 2015 13:50:36 GMT

please close this thread by marking the correct answer

Re: Help with creating new dimension using like/not like

jonathandienst — Tue, 22 Sep 2015 13:57:28 GMT

Another option

Pick(WildMatch(Service, '*Admin*', '*Complaint*', '*Claim*', '*Sale*') + 1, 'Other', 'Admin', 'Complaint', 'Claim', 'Sale')