Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Coalesce() function in Qlikview and Qlik Sense

andoryuu
Creator III
Creator III

Coalesce() function in Qlikview and Qlik Sense

To avoid nested If() statements, there should be a Coalesce() function that selects the first non-null value.  

3 Comments
Patric_Nordstrom
Employee
Employee

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,

Patric

Status changed to: Open - Collecting Feedback
daviewales
Contributor III
Contributor III

I just tested this in Qlik Sense June 2020, and it appears that Coalesce() exists as an undocumented function!

daviewales_0-1605657251663.png

@Patric_Nordstromcan you shed any light on this?

Patric_Nordstrom
Employee
Employee

@daviewales  yes I confirm coalesce is available and works, will appear in documentation in the near future.

Thanks,
Patric

Status changed to: Delivered