Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a simple select count sql statement which is not working from qlikview
SQL
Select
count(BusinessEntityID)
from [Person].[BusinessEntityAddress];
However same script is working from dbms.
I have used OLEDB connect statement
yes @mfchmielowski that worked
but without alias it does not work.
How does it work in db without alias
Hi.
Is that full load statement or did you forgot to add load. The good practice is to name result column in sql statements.
yes @mfchmielowski that worked
but without alias it does not work.
How does it work in db without alias
Hi. You need to tell qlik what column he had to load. In my case (MySQL as DB) code:
Table: load *; sql select count(id) from SomeTable;
loads one column named count(id).