topic Re: Script in QlikView

Script

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

hi in the edit script iam defining a variable and the part of date is below

''Aggr(Only({$<Date = {">=$(StartDate)<=$(EndDate)"}

you see after the execution in the front end when i take the variable into a input box and i see that the $ is changed to ==

and when i edited the variable in the script like below

''Aggr(Only({$<Date = {">=@(StartDate)<=@(EndDate)"}

now the out put is also coming like @ it shoul show me $ only ..

avinashelite — Fri, 03 Mar 2017 11:10:35 GMT

Set analysis does not work in script level

avinashelite — Fri, 03 Mar 2017 11:13:34 GMT

Go with the If condition and Aggr() function alos does not work in script you need to convert this into it using the

Group by clause

Anil_Babu_Samineni — Fri, 03 Mar 2017 11:22:20 GMT

Why you need this in Script instead of Set Operator.

May be try with Where condition of end of the script of that load source

sasiparupudi1 — Fri, 03 Mar 2017 11:33:26 GMT

Declare like the following

let x='Aggr(Only({$'&'<Date = {">=$'&'(StartDate)<=$'&'(EndDate)"}';

hth

Sas