topic Re: New to QlikView in Qlik Learning Discussions

New to QlikView

Fri, 30 Jan 2015 08:05:20 GMT

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 — Fri, 30 Jan 2015 08:10:21 GMT

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

Fri, 30 Jan 2015 08:25:05 GMT

Thanks, it worked perfectly...

maxgro — Fri, 30 Jan 2015 08:26:25 GMT

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