scripting

Anonymous — Wed, 21 Dec 2016 06:29:47 GMT

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

Re: scripting

avinashelite — Wed, 21 Dec 2016 06:53:13 GMT

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 !!!

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

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

topic scripting in QlikView

scripting

Re: scripting