Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

expression within a set analysis

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.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

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

//A.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

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

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

//A.