LiveQuery for Qlik Sense

Stretch LiveQuery for Qlik Sense logo

LiveQuery for Qlik Sense | Live Analysis in Qlik

Have you wanted to create a completely live dashboard in Qlik Sense?

LiveQuery for Qlik Sense helps you do just that. LiveQuery for Qlik Sense is a service that enables live queries directly from the Qlik Sense front-end to a specified data warehouse. The LiveQuery services acts as an intermediary between Qlik and the data warehouse without moving data to QVDs.

The result? Completely live Qlik Sense dashboards that can combine the power of live queries with in-memory data.

Stretch Qonnect is a certified Qlik Elite Solution Provider and won Qlik Solution Provider of the Year in EMEA for 2020.

Free Trial


Product Demo

Qlik Sense being for self-service business intelligence on computer

Live Queries in Qlik Sense

LiveQuery for Qlik Sense is a service that enables live queries directly from the Qlik Sense front-end to a specified data warehouse. No need to move data to QVDs with LiveQuery. The product is a service residing on a server. The LiveQuery service acts as an intermediary between Qlik and the data warehouse.

Live Queries with no QVDs

With LiveQuery you do not need to move data to QVDs in order use Qlik Sense. The service makes it possible to create queries from Qlik Sense without moving all the data in-memory, simplifying your architecture.

Seamless integration between live queries and in-memory
The LiveQuery service enables near-seamless integration between live queries and in-memory data. To achieve this the LiveQuery service dynamically transform the queries and links the query results to the Qlik data model, based on series of factors. This is done in real-time as the user is using the application.

In-memory cache
The LiveQuery service has an in-memory result cache. This means that repeated queries can return results without accessing the warehouse. This reduces the load on the data warehouse and increase the responsiveness of the Qlik front-end. The cache has a configurable time-to-live, when a query result in the cache surpasses this time, the result is evicted form the cache and the query is parsed on the data warehouse. This enables the administrators to balance the requirement between real-time data and load/cost on the data warehouse.

User specific queries
The LiveQuery service enables queries to parser on the information about which user is performing the query in the front-end. This enables support for user specific queries, reusing existing table and row-level access implemented to best practice standards for the data warehouse.

Frontend driven development
The LiveQuery service integrates into the Qlik Sense development GUI, which makes the development of applications utilizing LiveQuery simple and fast. No scripting or template applications are required, only SQL and some knowledge on the structure of the data warehouse.

Free Trial


Contact us