Discussion Board for collaboration related to QlikView App Development.
I have written this expression in a chart but I would like to move it to the script as a new field - it doesn't seem to be working. What could the issue be here?
@gilldilpreet Set analysis is a chart expression not a Script expression
can you share a sample data and the expected output ?
Set analysis syntax not able to use in Script.
You can try like below.
Load [Session Date], If([Session Date] = Date(Today(),'DD/MM/YYYY') and Sum_AttendedNumeric >=1, 'Y',
If([Session Date] = Date(Today()-1,'DD/MM/YYYY') and Sum_AttendedNumeric >=1, 'Y', 'N')) as [Attended In Last 2 Days];
Load [Session Date], Sum(AttendedNumeric) as Sum_AttendedNumeric resident Report1
where [Session Status] = 'Y'
group by [Session Date];
Note: Based on your screenshot, not able to find the Primary Key.
So above is the sample script, you can include your required field in the load statement and add those in group by.
Hope it helps.