topic Re: Qlik sense automatic load data in Connectivity & Data Prep

Qlik sense automatic load data

daviduzzo — Tue, 19 Apr 2016 08:56:19 GMT

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

Re: Qlik sense automatic load data

oknotsen — Tue, 19 Apr 2016 09:46:31 GMT

You could do so by using Direct Discovery:

- Direct Query ‒ Qlik Sense

- Direct Discovery

- Limitations

Re: Qlik sense automatic load data

daviduzzo — Tue, 19 Apr 2016 11:09:36 GMT

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

Re: Qlik sense automatic load data

Ralf-Narfeldt — Tue, 19 Apr 2016 13:38:20 GMT

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?

Re: Qlik sense automatic load data

daviduzzo — Tue, 19 Apr 2016 13:42:58 GMT

how do this? yes, is Qlik Sense Desktop

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

Re: Qlik sense automatic load data

oknotsen — Wed, 20 Apr 2016 11:42:19 GMT

We do not offer scheduling on the desktop version.

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

Re: Qlik sense automatic load data

daviduzzo — Wed, 20 Apr 2016 11:46:10 GMT

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

Re: Qlik sense automatic load data

oknotsen — Wed, 20 Apr 2016 11:51:11 GMT

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

See here:

Direct Query ‒ Qlik Sense

Re: Qlik sense automatic load data

daviduzzo — Wed, 20 Apr 2016 11:54:05 GMT

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