Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel value in Sql query

Hi!

I import a excel like this:

Articles:

LOAD

     Article,

     MinAnt,

     MaxAnt

FROM

;

Then I want to use theese values in my sql query like this:

Select Article, Maxant - CurAnt FROM values

WHERE CurAnt > MinAnt

How can I use the values from Excel in my sql query? 

Thanks in advance!

1 Reply
Not applicable
Author

I tried this:

Articles:

LOAD

     Article,

     MinAnt,

     MaxAnt

FROM

;

Temp:

Select Article, CurAnt FROM values;

left join(Articles)

Load *

RESIDENT Temp;

Can you please tell me how to write a SQL query that uses MinAnt and MaxAnt...

Any help is appreciated.

Thanks.