Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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!

Labels (1)
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.