Set Analysis greater than and less than

[#1]

Hi There,
I am having a problem on Qlikview 8.5 and I wondering if someone can assist.
See my screen shot below which displays a group name, month and member count for each month displayed.
The value 78 is the member count for the 1st month but it displays this value down through the rest of the list.

You can see in the second screen shot for example I've selected a singluar month and it displays 79 which is correct for that month however it displays as 78 in the full list.

To get the member count for a month we use an effective date and term date for each member. So if the effective date and term date are between the month this is what the member count is.
This is the set analysis expression I'm using

count

({<EFFECTIVE_DATE = {'<=$(=date(min(REPORT_DATE)))'} ,TERM_DATE = {'>=$(=date(min(REPORT_DATE)))'} >}
distinct MEMNO)

Thanks,
Kevin.

[#2]

Kevin,

I did come across few such scenarios wherein the field is not exactly relative. So aggregated at the time of load itself. So can't you use count(..) as <No Members> in the SQL SELECT/ LOAD itself instead of the run time?

-Arun

[#3]

Hi Sunil,

How do you mean not relative? Surely if there is an association then you can apply this logic through set analysis?

Can set analysis not handle such a criteria?

I dont think its possible for me to do this through the LOAD code.

Thanks,
Kevin.