Discussion Board for collaboration on QlikView Scripting.
I created a view that has a record count of 3 mio rows.
When loading it to qlik sense it fetches about 11 mio rows.
The used code is quite simple - it's just a SELECT id, date FROM my_view;
I really do not understand this - why does it happen?
any ideas, suggestions?
Go to Solution.
SELECT * from owner.table
should return the same rows in every tool (sense, sqlplus, sql developer, etc....)
Check you're using the same database and the same oracle user
Are you doing any joins in Qlik Sense?
Can you share the script over here
Only this table is loaded - the other parts are commented out...
The view contains the logic, I only want to display the results.
Later I will use the ID to join this table with the others.
But the count(*) is wrong, Qlik sense loads far too many rows.
Within the data preview I can now see "Start Dates" from "06.10.1954". Very strange.
I restricted the view to load only data from the current year.
This doesn't make any sense to me right now... What's going on ?
How does Start Date look in your database? Can you post some screenshots?
START_DATE is of data type <DATE>
The view has to be restricted, so I used this attribute within the WHERE-Clause.
No errors when executing in SQL-Developer. Very simple example...but in QS
i get this error.
How and at which place can you restrict the to be loaded data ?
...and which Syntax ? is there a special syntax necessary ?
Does Qlik Sense interpret the view in a different way ?
Connector reply error: ***
Where did you used the where clause? Select or Load?
I used the WHERE-clause when defining my view...
Oh the view already has the where clause... then you just did a direct select * from view? should not have error-ed out... not sure what might have caused it... Can you post the screenshot of the error message?