Script Question.

[bnelson111]

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

[#2 · Accepted solution]

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

[bnelson111]

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

[bnelson111]

Brilliant thanks, posted a thank you,