Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Script

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

4 Replies
avinashelite

Set analysis does not work in script level 

avinashelite

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

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sasiparupudi1
Master III
Master III

Declare like the following

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

hth

Sas