Discussion Board for collaboration related to QlikView App Development.
I have a simple select count sql statement which is not working from qlikview
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
View solution in original post
Is that full load statement or did you forgot to add load. The good practice is to name result column in sql statements.
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).