topic excel to qlikview in QlikView

excel to qlikview

inam — Mon, 24 Apr 2023 07:58:57 GMT

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

Re: excel to qlikview

rubenmarin — Mon, 24 Apr 2023 10:40:44 GMT

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,

Re: excel to qlikview

inam — Mon, 24 Apr 2023 11:18:21 GMT

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

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

Re: excel to qlikview

Kushal_Chawda — Mon, 24 Apr 2023 11:29:19 GMT

@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

Re: excel to qlikview

rubenmarin — Mon, 24 Apr 2023 14:15:31 GMT

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/ConditionalFunctions/match.htm

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')

Re: excel to qlikview

inam — Tue, 25 Apr 2023 04:32:08 GMT

Thanks Rubenmarin

working fine 😊

Re: excel to qlikview

inam — Tue, 25 Apr 2023 04:38:04 GMT

ok Kushal done

Tysm 🙂