topic Count Function in SQL not working from Qlikview in QlikView

Count Function in SQL not working from Qlikview

rohitgupta_ey — Mon, 24 May 2021 17:19:04 GMT

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

Re: Count Function in SQL not working from Qlikview

mfchmielowski — Mon, 24 May 2021 17:27:21 GMT

Hi.

Is that full load statement or did you forgot to add load. The good practice is to name result column in sql statements.

Re: Count Function in SQL not working from Qlikview

rohitgupta_ey — Mon, 24 May 2021 17:39:27 GMT

yes @mfchmielowski that worked
but without alias it does not work.

How does it work in db without alias

Re: Count Function in SQL not working from Qlikview

mfchmielowski — Mon, 24 May 2021 19:41:55 GMT

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).