topic Re: Excel value in Sql query in QlikView

Excel value in Sql query

Fri, 07 Dec 2012 09:28:38 GMT

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!

Fri, 07 Dec 2012 12:27:26 GMT

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.