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

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

Wed, 20 Apr 2011 11:23:06 GMT

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.

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

tresB — Wed, 20 Apr 2011 12:13:11 GMT

Hi,

Two options are there:

1. you have to JOIN the two tables and then you can use the same expression, OR

2. you can use APPLYMAP function without joining them

Regards, tresesco

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

Thu, 28 Apr 2011 13:12:41 GMT

Hi Tresesco

Thanks for your suggestion dear!

But the problem here is I cannot use Join/ApplyMap as there is no key field through which I can Join/ApplyMap between the two tables. I will be thankful to you if you can do the required change in the application which is there in the below post.

I don't know how I am going to join both the tables in to one without any key fields between them.

Please do reply!

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

Thu, 28 Apr 2011 15:19:54 GMT

I think if you post a sample of your qvw it would be much easier to figure this out b/c as is I'm pretty confused.