Qlik sense automatic load data

[daviduzzo]

How you can make with Qlik sense loading data in real time from a sql database?

[oknotsen]

You could do so by using Direct Discovery:

- Direct Query ‒ Qlik Sense

- Direct Discovery

- Limitations

[daviduzzo]

some way to schedule the data load when the program starts or the F5 pressure?

[Ralf-Narfeldt]

You can schedule an app to reload according to a time schedule, or triggered by another reload in QMC, but not when the program starts. Do you mean in Qlik Sense Desktop?

[daviduzzo]

how do this? yes, is Qlik Sense Desktop

or I can put a button loads data directly in the app

[oknotsen]

We do not offer scheduling on the desktop version.

If you want scheduling, buy a few tokens and run a server .

[daviduzzo]

OK, thank. And is possible use SQL syntax in direct discovery?

[oknotsen]

After the "from" part, you can add a "where" part.

See here:

Direct Query ‒ Qlik Sense

[daviduzzo]

Yes but in direct query i divide dimension measure and detail, in the simple query sql it is not