oracle decode() in Qlik

[mahitham]

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.

[jonathandienst · Accepted solution]

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.

[mahitham]

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.

[jonathandienst]

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.