Urgent reply please

[#1]

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]

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

[#3]

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]

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

Jonathan