topic Re: direct query in QlikView

direct query

Mon, 26 May 2014 13:06:13 GMT

I am using direct query to search data . When I am testing this function .After loading , the file often appear no response . I must re-start the qvw again and load again . Whether are any settings for this kinds of large data ? I am using SR11.20SR5.

Re: direct query

rbecher — Mon, 26 May 2014 13:11:34 GMT

Hi Jack,

what is the data source for your direct query? What do you mean with "to search data"?

- Ralf

Re: direct query

Mon, 26 May 2014 13:42:02 GMT

I am using databases infobright. I am using direct discovery. I set up a pivtol table with measure fileds. After reload ,the qvw file appear noresponse.

Re: direct query

rbecher — Mon, 26 May 2014 13:46:34 GMT

You should try with a simple chart with a few dimensions and one measure first. QlikView will fire a lot of aggregational queries against the database after the reaload in the background, at least one per measure...

Re: direct query

Mon, 26 May 2014 13:52:02 GMT

You means I should always min the table before reloading .

Re: direct query

rbecher — Mon, 26 May 2014 13:54:40 GMT

No, I would start with a simple chart to test direct discovery. Probably not with a pivot table..

Re: direct query

Mon, 26 May 2014 14:11:55 GMT

Now I am testing. I find it is difficult to use because it take too long time or become noreponse. My direct table have 166,877,762 rows data.

Re: direct query

rbecher — Mon, 26 May 2014 14:20:25 GMT

It very depends on how fast these direct queries can be processed on the backend database.. You can trace them with the ODBC driver.

Re: direct query

Mon, 26 May 2014 14:28:27 GMT

How to find the reason when a .qvw file become no-respone ? My .qvw file always no-respone when I load mass data or a tables with too much data .then I have to stop it and lose all modifications .