Direct Query Not Working Qlik Sense

[poojask123]

Hi,

 I am connecting to a SQL table using Direct Query in Qlik Sense, script is as below. However, i dont think the app is maintaining a live connection to bring data into the dashboard. I update/insert data in the db but the same is not reflected in Qlik Sense without a manual reload every time. Need help in understanding if  I am doing anything wrong here. I have dimension tables for PatientType,Doctor,Department and ICD.

Fact:
DIRECT QUERY dimension
Patient_Type_key,
Convert(varchar,[Invoice_Date],106) as InvoiceDate,
AppointmentDateTime,
[Doctor_Code] as DoctorKey,
[Doctor_department],
[ICDCODE]
measure
[Total_Amount],
[HospitalNO],
[OutPatient] ,
[InPatient],
WaitTime
FROM [A].[dbo].[ABC]
Where Invoice_Date >='2021-03-01 00:00:00.000'
and WaitTime>0;

Qlik Sense Business

[Bastien_Laugiero]

Hello, 

My understanding with Direct Discovery is that it is facing a lots of limitation and no new developments are going on to overcome the limitations. 

Perhaps you are facing on of these limitation. Here is some documentation that may help:

• Accessing large data sets with Direct Discovery

• Limitations when using Direct Discovery

I believe the recommendation would be to use ODAG (On Demand App Generation) which offers a more flexible solution

• On-demand apps

Hope this helps!