Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Excel value in Sql query

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.

Community Browser