Trying Set analysis results is error in expression

[lcclcc]

I don't know how to find the qlik version, but I am using qlik sense enterprise. trying to use set analysis. why does this "error in expression"? trying to create a measure object of this

Count({<
// This is the Set Analysis that filters your data
[USER_ACCESS_ORG_CODE] = {"=
// The condition checks if the org code is within the range
// of your variables. It also handles the case where variables are empty.

// If vMinOrgRange is empty, this condition is met.
(IsNull('$(vMinOrgRange)') OR [USER_ACCESS_ORG_CODE] >= '$(vMinOrgRange)')

AND // Combine with the max range condition

// If vMaxOrgRange is empty, this condition is met.
(IsNull('$(vMaxOrgRange)') OR [USER_ACCESS_ORG_CODE] <= '$(vMaxOrgRange)')

// AND ensure the org code is not null
AND IsNull([USER_ACCESS_ORG_CODE]) = 0
"}
>} * )

[WeLoveQlik]

The first thing I would try is replace your AND with a comma.

ln set analysis listing multiple conditions separating by a comma and is the default.

[lcclcc]

no luck I removed two AND and replace with ,

I also tried this to troubleshoot and it says count needs one parameter, as a new person, not sure if it is a valid test

Count({<
// This is the Set Analysis that filters your data
[USER_ACCESS_ORG_CODE]
>} )

[WeLoveQlik · Accepted solution]

You can try replacing the * with 1. which will count each row but it might be better to count a unique field or some other field in your data model that you want to count.