Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to use a variable during reloading data

hi

I create a variable and i try to restrict the data from the DB by using WHERE close during reloading data.

Is my syntax OK ?

i attache the error message

Failures:

 

LOAD Serial_Number,

     Name,

     Date,

     event_recnum,

     Engine_Number,

     SW_Version,

     EndTime,

     Imps_Counter,

     Restarts_During_Recovery,

     WeekendTimeDuringFailure,

     DownTimeDuringFailureWeekend,

     DownTimeDuringFailureRegular,

     NightTimeDuringFailure,

     NightModeTimeDuringFailure,

     SpecialCustomerJobs_Imps,

     SpecialJobs_Imps,

     [RecoveryTime(seconds)],

     NullsDuringFailure

FROM

Data\iserve_Data.xlsx

(ooxml, embedded labels, table is SHARONֹFAILURES)

where Date >= $(V_max_date);

  

store Failures into $(path_xls)Failures.qvd;

2 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi sharon,

You have to put the variable inside single quotes like below

where Date >= '$(V_max_date)';

Deepak

Not applicable
Author

thank you