topic Re: Count is not matching with Record Set In qlikview script in QlikView

Count is not matching with Record Set In qlikview script

Anonymous — Mon, 28 Jan 2013 16:44:37 GMT

Hi,

When I am running below script in Qlikview it is giving correct count ie 1049873:

SQL SELECT count(1)

FROM DataSchema.Data_v

WHERE business_date >= TO_DATE('2012-07-01 00:00:00','YYYY-MM-DD HH24:MI:SS')

AND business_date <= TO_DATE('2012-07-31 00:00:00','YYYY-MM-DD HH24:MI:SS')

Where as if I run all the columns selections then it is giving only just 2500 records

SQL SELECT *

FROM DataSchema.Data_v

WHERE business_date >= TO_DATE('2012-07-01 00:00:00','YYYY-MM-DD HH24:MI:SS')

AND business_date <= TO_DATE('2012-07-31 00:00:00','YYYY-MM-DD HH24:MI:SS')

Is there any specific settings i need to provide to achieve this?.

I am using licenced version of qlikview and ODBC connector.

Thanks

Dasu.G

Re: Count is not matching with Record Set In qlikview script

alexandros17 — Mon, 28 Jan 2013 16:58:01 GMT

How do you count rows in resulting tables?

With the first query you just count the rows, the second query may "hide" rows if values are equal. Is this possible in your tables?

Re: Count is not matching with Record Set In qlikview script

Anonymous — Mon, 28 Jan 2013 17:18:55 GMT

Ticket number and business date columns are different always. complete record set never matches at all..

Re: Count is not matching with Record Set In qlikview script

Anonymous — Mon, 28 Jan 2013 23:12:28 GMT

Hi Guys,

I found below logs from ODBC Driver?. Is there any thing to do with ODBC (We are using Composite 6.2 ODBC driver).

0002DED44EB9471 2dd74-2dd78	EXIT SQLSetStmtAttrW with return code -1 (SQL_ERROR)
		SQLHSTMT 0x00000000003EE260
		SQLINTEGER 4 <SQL_ATTR_ASYNC_ENABLE>
		SQLPOINTER 1 <SQL_ASYNC_ENABLE_ON>
		SQLINTEGER -6

Re: Count is not matching with Record Set In qlikview script

rwunderlich — Tue, 29 Jan 2013 00:04:16 GMT

It sounds like your driver (or DB) is set to return a max of 2500 rows. Is that SalesForce you are hitting in the background?

-Rob

Re: Count is not matching with Record Set In qlikview script

Anonymous — Tue, 29 Jan 2013 00:26:21 GMT

Hi Rob,

I ran other queries and found that those are retrieving more than 2500 rows that means neither db nor database has this record limit configured. Do you have any thoughts how to proceed on these kind of situations?.

Thanks

Dasu.G

Re: Count is not matching with Record Set In qlikview script

Anonymous — Tue, 12 Feb 2013 00:56:23 GMT

We found some issues in the composite ODBC driver . There is no issue in QV.