expression within a set analysis

Anonymous — Tue, 05 Jul 2011 13:38:15 GMT

Hi!

I want to count number of persons that's got one or more points over the last 30 days.

I figured it would be something like this;

count({$<Name= {"=sum({$<Date={">=$(=today()-30) <=$(=today())"}>} Points)>0"} >} distinct Name)

But it doesn't work.

I'm I on the right track or is it done in another way?

Thanks.

//A.

Anonymous — Tue, 05 Jul 2011 14:14:52 GMT

I made it harder than it was. Here's the sollution:

count({$<Date={">=$(=date(today()-30)) <=$(=date(today()))"} >} distinct Name)

//A.

topic expression within a set analysis in QlikView