28 May 2026

Engine functions in Direct Query expressions

Share this message

Direct Query now supports using Qlik Engine functions within $(=…) expressions in KPIs and custom SQL statements. You can use GetUserAttr and if functions to create dynamic, user-context-aware data filtering. This enables you to implement row-level security and personalized data access in Direct Query applications without loading data into memory.

Accessing cloud databases directly with Direct Query

Custom SQL examples for Direct Query

How can we help?

Barry has over 20 years experience as a Data & Analytics architect, developer, trainer and author. He will gladly help you with any questions you may have.