Direct Query development

[zuk]

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).

1. Table and bar chart: In this case, it shows that there is an error in the direct discovery expression.
2. 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.