topic Re: like in QlikView

like

master_student — Tue, 09 May 2017 16:16:09 GMT

Hello Guys,

I need a function that do like that : if Location like %RESTO%

is there any function that do that?

Thanks

Re: like

sunny_talwar — Tue, 09 May 2017 16:18:08 GMT

Yes, it should be like this

If(Location LIKE '*RESTO*', TrueCondition, FalseCondition)

Re: like

Anil_Babu_Samineni — Tue, 09 May 2017 16:18:45 GMT

You can use directly like operation or WildMatch(Location,'*RESTO*')

Re: like

stigchel — Tue, 09 May 2017 16:24:05 GMT

Can you also use % as wildcard character? From the help:

like	String comparison with wildcard characters. The operation returns a boolean true (-1) if the string before the operator is matched by the string after the operator. The second string may contain the wildcard characters * (any number of arbitrary characters) or ? (one arbitrary character).
	Examples: 'abc' like 'a' returns true (-1) 'abcd' like 'a?c' returns true (-1) 'abc' like 'a??bc' returns false (0)

Re: like

Anonymous — Tue, 09 May 2017 17:18:08 GMT

Like others have said, WILDMATCH is the way to go!

Re: like

Anil_Babu_Samineni — Tue, 09 May 2017 17:20:21 GMT

If you got the Correct Answer. Please flag the correct answer and helpful

Re: like

master_student — Thu, 11 May 2017 10:00:02 GMT

Hello Guys,

Thanks for your reactions ) I appericiate your help. I have an other request, I have a filed TIME on second I would like to convert it into Hours / minute

ANY IDEA please?

Re: like

sunny_talwar — Thu, 11 May 2017 10:52:39 GMT

May be like this

Time(Time#(Field, 'ss'), 'h:mm') as Field