Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Doing Expression Calculation in the Script and using aggregation table(using resident)

Hi All

How to do the below calculation in the script level which I am doing it in the expression? I am trying to do this as the performance is poor when I am doing it in the front end.

SUM(IF(StartDate<=date AND EndDate>=date,1))

For your information, Fields ImplStart and ImplEnd are loaded from table 'Data' and 'date' is getting loaded from another table called 'Calendar'

I thought of creating the aggregation table but the problem is data is getting loaded from two tables. So I dont know how to use the 'Resident' to load data from two tables.