excel to qlikview

[inam]

Hi Community

=IF(ISNUMBER(SEARCH("Air Arabia",AE3))=TRUE,"Air Arabia Landing Page",IF(ISNUMBER(SEARCH("pkg",AX3))=TRUE,"PDP",IF(ISNUMBER(SEARCH("tour-package",AX3))=TRUE,"SRP","Other")))

this is excel formula ..I want same formula in Qlikview 

here AE3 is [Campaign Name], and AX3 is [page url]

expected output:-

Air Arabia

Air Arabia Landing Page

other

PDP

SRP

if(wildmatch([Campaign Name], 'Air Arabia', 1), 'Air Arabia Landing Page',if(wildmatch([Page URL], 'pkg', 1), 'PDP',if(wildmatch([Page URL], 'tour-package', 1), 'SRP','Other'))) as arabia_vistara,    

I try this but not getting answer

[rubenmarin · Accepted solution]

Hi, can you try this?:

if(wildmatch([Campaign Name], '*Air Arabia*'), 'Air Arabia Landing Page',if(wildmatch([Page URL], '*pkg*'), 'PDP',if(wildmatch([Page URL], '*tour-package*'), 'SRP','Other'))) as arabia_vistara,    

[inam]

Thanks Rubenmarin .... its working fine 😊

i have one more column 

Excelformula 

=IF(OR(ISNUMBER(SEARCH("guidelines",AX2))=TRUE,ISNUMBER(SEARCH("guidelines",AE2))=TRUE),"TG","NonT") 

I want same formula in Qlikview .

Expected output :-

guidelines

Non TG

TG

i try this 

if(match('guidelines', [Page URL]) or match('guidelines', [Campaign Name]) , 'TG', 'Non TG') as new_guidelines,  but getting only  Non TG  in  gidelines column

[Kushal_Chawda]

@inam  use Index function instead wildmatch. If you are using wildmatch , you need to wrap your search string with '*'

if(index([Campaign Name], 'Air Arabia', 1), 'Air Arabia Landing Page',
if(index([Page URL], 'pkg', 1), 'PDP',
if(index([Page URL], 'tour-package', 1), 'SRP','Other'))) as arabia_vistara 

[rubenmarin · Accepted solution]

Hi, the first parameter of the match function is the field the search, and next parameters are the values to search:

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona...

So: if(match([Page URL],'guidelines') or match([Campaign Name],'guidelines') , 'TG', 'Non TG') 

or in wildmatch:

if(wildmatch([Page URL],'*guidelines*') or wildmatch([Campaign Name],'*guidelines*') , 'TG', 'Non TG') 

[inam]

Thanks Rubenmarin 

working fine 😊

[inam]

ok Kushal done 

Tysm 🙂