topic Re: Reg: LIKE in SQL - Qlikview..? in QlikView

Reg: LIKE in SQL - Qlikview..?

lakshmanvepuri — Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

Please advise me how to use this in Qlikview scripting.

=if ( KEY_ID LIKE 'L%-L%' or KEY_ID LIKE 'L%M%SK%, x+1, y+1)

Any Example to use Match, WildMatch functions in Qlikview.

Sample data for KEY_ID:

L1GB-MSK

L1KB-MSK

L1LA-MSK

LEPLY-LEP

L05BMASK

L05EMASK

Thanks

Kumar

Re: Reg: LIKE in SQL - Qlikview..?

amayuresh — Tue, 29 Mar 2016 03:11:14 GMT

Try this,

=Pick(WildMatch([Bid Item No.],'Anti*Bo*','Anti*C*','Anti*Sof*'),'A','B','C')

Output:

Re: Reg: LIKE in SQL - Qlikview..?

tamilarasu — Tue, 29 Mar 2016 03:29:42 GMT

Hi,

You can use like operator in Qlikview. You can also use wild match function like below.

IF ( KEY_ID LIKE 'L*-L*' OR KEY_ID LIKE 'L*M*SK*', 'x+1', 'y+1') as Test1, // Method 1

IF(WildMatch(KEY_ID, 'L*-L*', 'L*M*SK*'), 'x+1', 'y+1') as Test2; // Method 2

Re: Reg: LIKE in SQL - Qlikview..?

amit_saini — Tue, 29 Mar 2016 04:28:04 GMT

Hi,

try :

Syntax:

LOAD Products,

City,

pick( WildMatch(City,'*Punjab*','*Haryana*','*Delhi*'),'P1','P2','P3')

as Data

FROM

Prcatice.xlsx

(ooxml, embedded labels, table is Sheet3);

Thanks,

Re: Reg: LIKE in SQL - Qlikview..?

tyagishaila — Tue, 29 Mar 2016 06:06:41 GMT

Try it,

KeyId:

Load * Inline [

KEY_ID

L1GB-MSK

L1KB-MSK

L1LA-MSK

LEPLY-LEP

L05BMASK

L05EMASK

];

Load *,

Pick(WildMatch([KEY_ID],'L*L*'),[KEY_ID]) as newKey1,

Pick(WildMatch([KEY_ID],'L*M*SK*'),[KEY_ID]) as newKey2

Resident KeyId;

DROP Table KeyId;

Re: Reg: LIKE in SQL - Qlikview..?

MayilVahanan — Tue, 29 Mar 2016 06:24:34 GMT

Try like this

Load *, if (WildMatch(KEY_ID,'L*-L*', 'L*M*SK*'), 1, 2) as NewField Inline

[

KEY_ID

L1GB-MSK

L1KB-MSK

L1LA-MSK

LEPLY-LEP

L05BMASK

L05EMASK

];

Re: Reg: LIKE in SQL - Qlikview..?

Kushal_Chawda — Tue, 29 Mar 2016 06:30:35 GMT

see this below link to understand Wildmatch fucntion

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ConditionalFunctions/wildmatch.htm?q=wildm…