QlikView App Dev

[newhere2014]

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.

[TKendrick20]

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.

[newhere2014]

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

[TKendrick20]

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.

[newhere2014]

This is my code, but it can not run.

CloseMonth:

LOAD * INLINE [

    Month_1

    5

];

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;

[#6 · Accepted solution]

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;

[newhere2014]

This code works.  Peek function solved my problem.

Thanks all of you.