Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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())