topic Re: Urgent reply please in QlikView

Urgent reply please

Thu, 06 Jun 2013 09:58:51 GMT

Hi...what is the equivalent function of DECODE in qlikview....for example i have this one related to oracle

"DECODE(CHROMATIC_MODE, 'N/A', NULL, 'NA', NULL, CHROMATIC_MODE) AS CHROMATIC_MODE " how we can use it in qlikview....pls help me to get this...

Thanks & Regards,

Anitha.

Anonymous — Thu, 06 Jun 2013 10:01:42 GMT

Again, taken from online Oracle documentation:

In Oracle/PLSQL, the decode function has the functionality of an IF-THEN-ELSE statement.

The syntax for the decode function is:

decode( expression , search , result [, search , result]... [, default] )

The if statement I posted on your other question about the NPL2 function would work.

Jonathan

Thu, 06 Jun 2013 11:26:21 GMT

thanks for that reply....but how can use i my case

DECODE(CHROMATIC_MODE, 'N/A', NULL, 'NA', NULL, CHROMATIC_MODE) AS CHROMATIC_MODE

Regards,

sh.

Anonymous — Thu, 06 Jun 2013 11:29:52 GMT

if(match(CHROMATIC_MODE,'N/A','NA'), NULL(), CHROMATIC_MODE) AS CHROMATIC_MODE

Jonathan