Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

facing issue with decode

Hi....need to use IF-THEN-ELSE Condition for the below one....pls can any one help me to get this i'm totally new to qlikview....

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

Thanks & Regards,

SH.

1 Reply
alexandros17
Partner - Champion III
Partner - Champion III

     if((CHROMATIC_MODE = 'N/A' or CHROMATIC_MODE = 'NA', null(), CHROMATIC_MODE)