topic Re: where clause in script in QlikView

where clause in script

newhere2014 — Tue, 16 Jul 2013 20:01:45 GMT

Hi all,

I need Month condition for a WHERE clause in QV script. Month value is stored in a excel sheet. How can I use Month value from a excel sheet? Thanks.

the script is like this:

Load Year,

Month,

Sales

from table1

where Month > x;

x is a value stored in the excel sheet,which is changed manually monthly.

Re: where clause in script

TKendrick20 — Tue, 16 Jul 2013 20:12:41 GMT

Hard code the x value into the QV script and change it there manually rather than on the excel sheet? Otherwise you could make the x value its own column in the excel sheet.

Re: where clause in script

newhere2014 — Tue, 16 Jul 2013 20:17:11 GMT

Hard code is not an option for now.

Right now, x value is stored in excel as a column. But how to use it in script? Thanks

Re: where clause in script

TKendrick20 — Tue, 16 Jul 2013 20:21:50 GMT

Could you provide a sample of how data is loaded into table1?

It makes a huge difference if the Month values are January, February, March or 01, 02, 03.

Re: where clause in script

newhere2014 — Tue, 16 Jul 2013 20:27:42 GMT

This is my code, but it can not run.

CloseMonth:

LOAD * INLINE [

Month_1

];

SET vMonth=Month_1;

T1:

LOAD * INLINE [

Month, Sales

1, 45

2, 5

3, 63

4, 232

5, 5

6, 445

7, 34

8, 65

];

load Month as M,

Sales

Resident T1

where Month>$(vMonth);

drop table T1;

Re: where clause in script

Tue, 16 Jul 2013 20:30:06 GMT

temp:
LOAD Month
FROM

(biff, embedded labels, table is [Sheet1$]);

LET VTest=Peek('Month');

LOAD Name,
Month,
Sales
FROM

(biff, embedded labels, table is [Sheet1$])
WHERE(Month > $(VTest) );
DROP Table temp;

Re: where clause in script

newhere2014 — Tue, 16 Jul 2013 20:33:54 GMT

This code works. Peek function solved my problem.

Thanks all of you.