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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
kristeljoymalapitan

Functions and Syntax on Qlik Sense ?

Good Day.

May I ask questions regarding syntax/function on Qlik Sense.

What is the equivalent  syntax of CASE WHEN  in Qlik Sense?


Please see below sample query

SELECT  CASE WHEN computed_dpd <=0 THEN 0 ELSE computed_dpd END computed_dpd_sample FROM temp_table;

scenario: to set computed_dpd to zero (0) if <=0 else retain the value of computed_dpd

0 Replies