Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

scripting

Hi All

I had a [Main Table] in QVW using the Binary load

I had two variables like vstart and vEnd  which are created in the Variable overview  i want to used this variable in script level

return expression in my script was like this does it works  and if i change the date of this variable values  using calendar object does not works with out reloading the app please advice

NoConcatenate

Table_temp:

Load Name,

  Hours,

    Year,

  Month,

  Week,

  Sum(HOURS) as total hours

       Resident [Main Table]

where ('$(vStart)')<=Date>=('$(vEnd)')

     Group by Name ;


Drop  table [Main Table];

does it works  please advice

1 Reply
avinashelite

syntax is wrong

where Date>='$(vStart)' and Date<=('$(vEnd)')

have you set the variables

vStart and vEnd ?


if you changing the variable in the front end and the to reduce the data you have reload !!!

Or

to filter the data add a condition in the set analysis or the expression as below

if(Date>=vStart  and Date<=vEnd, sum())