New to QlikView

[#1]

I am completely new to this QlikView world, but is on my way... 🙂

I have many questions, but will take them one at the time...

Is there anyone, who help/guide me whit this query?

SQL select * from receiptline l, receipt r where r.created < "2015-01-01 00:00:00" and r.created > "2014-01-01 00:00:00" and l.receipt=r.id;

Is this the right way to write it in QlikView?

[alexandros17 · Accepted solution]

In your query you are selecting all the fields * from more than one table, in this case tables must be linked in some way, you should write:

SQL select * from receiptline l left join receipt r on  l.receipt=r.id where r.created < "2015-01-01 00:00:00" and r.created > "2014-01-01 00:00:00";

hope this helps

[#3]

Thanks, it worked perfectly...

[maxgro]

maybe it works if the sql result set doesn't have duplicate field names

usually if a select statement works on your dbms it also works in QlikView as the SQL statement is sent to the dbms for the execution

some help here

Preceding Load