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.
