Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.