topic Set Analysis greater than and less than in QlikView

Set Analysis greater than and less than

Wed, 29 Jul 2009 17:15:02 GMT

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.

Set Analysis greater than and less than

Wed, 29 Jul 2009 17:52:48 GMT

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

Set Analysis greater than and less than

Wed, 29 Jul 2009 18:30:16 GMT

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.