topic oracle decode() in Qlik in QlikView

oracle decode() in Qlik

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

Hi Experts,

Can any one please help me on replicating below Oracle decode() logic into Qlik.

decode(Product, 'Y' , 'b' , 'N' , 'a' , null)

Thanks in advance.

Re: oracle decode() in Qlik

jonathandienst — Wed, 11 Apr 2018 09:32:45 GMT

Like this:

(case-sensitive)

=Pick(Match(Product, 'Y', 'N'), 'b', 'a')

(case-insensitive)

=Pick(WildMatch(Product, 'Y', 'N'), 'b', 'a')

Will return Null() if Product is anything other than 'Y'; or 'N' (or 'y', 'n') for case-insensitive version.

Re: oracle decode() in Qlik

mahitham — Wed, 11 Apr 2018 10:11:43 GMT

Hi Jonathan,

Thanks for your help.

In my query I have

derive_day_count(p.metricname)

is derive_day_count is the function of oracle. which function need to use alternatively in Qlikview. Please help me.

Re: oracle decode() in Qlik

jonathandienst — Wed, 11 Apr 2018 11:17:11 GMT

I am not sure that derive_day_count is an Oracle built-in function. I suspect that it is a user defined function. Start a new thread and explain exactly what you expect the function to do and I or someone else will be able to help.