topic Direct Query development in App Development

Direct Query development

zuk — Mon, 19 Jun 2023 15:28:02 GMT

Hi all,

I'm developing a prototype app to explore the possibilities of direct query in Qlik Sense.

I want to create a very basic app that reads a table from an sql server database and displays the data in a table on the front end.

To do this, I have created a very simple script that contains the direct query written as follows:

LIB CONNECT TO 'Tirocinante:MSSQL Sogesi'; [JB_AnagraficaArticoli_DirectQueryTest]: DIRECT QUERY DIMENSION CodArticolo, DescrArticolo MEASURE IdAzienda FROM JUSTBUSINESS.dbo."JB_AnagraficaArticoli";

The connector i'm using is the basic "Microsoft Sql Server".

The script loads without any errors.

At the front-end, when creating 3 visualizations that contain the fields I loaded through direct query, I encounter three different behaviors (refer to the attached image).

Table and bar chart: In this case, it shows that there is an error in the direct discovery expression.
Filter box: When displaying the dimensions in the filter box, they appear correctly.

What mistake am I making?

PS: I know I could create an app entirely using "IMPORT LIVE" with direct query, but that's not what I want to do at the moment.

Thank you.