This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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:
where Month > x;
x is a value stored in the excel sheet,which is changed manually monthly.
temp:LOAD MonthFROM(biff, embedded labels, table is [Sheet1$]);
LOAD Name, Month, SalesFROM(biff, embedded labels, table is [Sheet1$])WHERE(Month > $(VTest) );DROP Table temp;
View solution in original post
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.
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
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.
This is my code, but it can not run.
LOAD * INLINE [
load Month as M,
drop table T1;
This code works. Peek function solved my problem.
Thanks all of you.