Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

New to QlikView

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?

1 Solution

Accepted Solutions

Re: New to QlikView

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 Replies

Re: New to QlikView

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

Not applicable

Re: New to QlikView

Thanks, it worked perfectly...

MVP
MVP

Re: New to QlikView

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

Community Browser