Direct Query issue

Sun, 10 Jan 2016 19:08:10 GMT

Hi,

I'm connecting qlik to a 50B table using the following:

DIRECT QUERY

DIMENSION

CustomerID,

OrderDate,

...

MEASURE

Revenue,

ItemsQTY,

...

FROM DB.Table;

On the UI everything is working perfect.

The problem is that every time I reload my model it queries "DISTINCT CustomerID" and "DISTINCT OrderDate", this takes a very long time and kills the DB

Is there any way I can prevent qlik of doing this and feed it with the distinct CustomerID from a different table (we have only 10M customers not 50B)

Or reload the increment distinct customers (say from the last 2 days)

Thanks,

Benji

topic Direct Query issue in QlikView

Direct Query issue