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

Announcements
We are aware of an issue with the Product Downloads page and looking into it.
cancel
Showing results for 
Search instead for 
Did you mean: 
kalmirall
Contributor III
Contributor III

Quick question on set analysis formula

I'm trying to add in a piece to my set analysis formula to add a condition of having an assignment submission date in addition to an attempt.  The first formula is working fine:

Count(DISTINCT {$ <[assignmentsubmissions.attempt]={">=1"}>} [CanvasSchools.CanvasEnrollments.user_id])

But when I try to add in that second piece:

Count(DISTINCT {$ <[assignmentsubmissions.attempt]={">=1"}, len([assignmentsubmissions.submitted_at])={"<>0"}>} [CanvasSchools.CanvasEnrollments.user_id])

The formula wizard says I have an error in my set modifier expression.  I'm new to set analysis so any tweaks/help appreciated- hoping there is a quick and easy answer!

Thanks!

1 Reply
swuehl
Champion III
Champion III

You need to use field names, no expressions allowed, left of the equal sign in a set modifier.

Maybe try like this

Count(DISTINCT {$ <[assignmentsubmissions.attempt]={">=1"}, [assignmentsubmissions.submitted_at] ={"*"}>} [CanvasSchools.CanvasEnrollments.user_id])