Skip to main content

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Coalesce() function in Qlikview and Qlik Sense

andoryuu
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

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

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

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

Thanks,
Patric

Status changed to: Delivered