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)
