Larger Resultset from View

[#1]

Hello,

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?

[sunny_talwar]

Are you doing any joins in Qlik Sense?

[Anil_Babu_Samineni]

Can you share the script over here

[#4]

LOAD ID,
  [Measure_1],
  [Start Date],
  [Month],
  [Year];


[my_table]:
SELECT "ID",
  "Measure_1",
  "Start Date",
  "Month",
  "Year"
FROM "db_mydb"."myview";

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.

[#5]

Interesting phenomenon!

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 ?

[sunny_talwar]

How does Start Date look in your database? Can you post some screenshots?

[#7]

Hello!

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 ?

Please help

Connector reply error: ***

Error: ?

[sunny_talwar]

Where did you used the where clause? Select or Load?

[#9]

I used the WHERE-clause when defining my view...

[sunny_talwar]

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?