Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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
Highlighted
deepakk
Valued Contributor III

Re: how to use a variable during reloading data

hi sharon,

You have to put the variable inside single quotes like below

where Date >= '$(V_max_date)';

Deepak

Not applicable

Re: how to use a variable during reloading data

thank you