topic Re: Script Question. in QlikView

Script Question.

bnelson111 — Wed, 27 Feb 2013 17:11:43 GMT

New with Qlikview, can anyone help?

I have loaded a ODBC script all okay, but now wish to search using wildcard for certain text in a record set, once found enter it to a new table called Item Type, I know I’m missing something but can’t think.

if(WildMatch((ItemCode),'t*'),'Trials','Not Trials'),if(WildMatch((ItemCode),'f*'),'Finger Prints')
as [Item Type],

What i want to end up with is a table with Trials, Not Trials and Finger Prints so either can be selected by user.

Above code is given the following Tables. so how do i get Not Trials and Trials into Item Type Table? Cheers

Re: Script Question.

Wed, 27 Feb 2013 17:26:24 GMT

Hello there, and welcome to the world of QlikView.

I think your problem is the close bracket after "Not Trials" which closes off the first "If" statement.

You might want to try something like this :

If (WildMatch(ItemCode,'f*'),'Finger Prints',

If (WildMatch(ItemCode,'t*'),'Trials',

'Not Trials') as [Item Type],

Good luck and keep trying

John

Re: Script Question.

bnelson111 — Wed, 27 Feb 2013 17:57:56 GMT

Thankyou, sometimes cant see the wood for the trees. Worked 100% just needed another bracket after 'Not Trials'))

Re: Script Question.

bnelson111 — Wed, 27 Feb 2013 18:00:19 GMT

Brilliant thanks, posted a thank you,