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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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