Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to use direct discovery in Qliksense 3.1.
I have created excel doc as datasource(32 bit system DSN). Connecting through ODBC.
Code:
LIB CONNECT TO 'Excel1 (qlik-sense_adminstrator)';
DIRECT QUERY dimension Product
Sales,
Quantity
FROM `C:\Users\admin_1\Sample\sales order1`.`'Sales Orders$'`;
Qliksense supports direct discovery. Still why this measure is not populating properly? Any idea ?
Thanks
Khushboo
Hi khushboo,
I myself have only recently started using the Direct Discovery feature and am still facing some issues of my own (I actually came around yours while looking for documentation on mines).
I could only reproduce your scenario if I mistakenly added a comma to the last dimension. Using your example:
LIB CONNECT TO 'Excel1 (qlik-sense_adminstrator)';
DIRECT QUERY dimension Product,
Sales,
Quantity
FROM `C:\Users\admin_1\Sample\sales order1`.`'Sales Orders$'`;
Removing that trailing comma did the trick, but again If you can provide a more detailed explanation of your scenario I may be able to help you out