Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
BaNANA
Contributor II
Contributor II

Error in set modifier expression in count with multiple conditions

Hi, I have a Qlikview expression Count({<[Product Engineer]={"Blank"},Len(SITE_ID)={">0"}>} Distinct PART_NO)

The expression has a redline on: {">0"}>} Distinct PART_NO). The error message on top of script window says Error in set modifier expression. What could be wrong?

5 Replies
usamabinsadiq
Contributor III
Contributor III

Hi,

please try this:

Count({<[Product Engineer]={"Blank"},Len(SITE_ID)={"$(= '>' & 0)"}>} Distinct PART_NO)

I hope this helps.

 

Regards, 

if my replay helped you then please press like button and do not forget to press the "Accept as Solution" button.
BaNANA
Contributor II
Contributor II
Author

I tried this but same error as original. 

Brett_Bleess
Former Employee
Former Employee

Have a look at the following Design Blog post, hoping that may contain the info you need to sort out the error:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Here is Help link as well:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Saravanan_Desingh

Try this.

Count({<[Product Engineer]={"Blank"},PART_NO={"=Len(SITE_ID)>0"}>} Distinct PART_NO)

 

Brett_Bleess
Former Employee
Former Employee

If Saran's last post got you a working solution, please do not forget to return to your thread and close it out by using the Accept as Solution button on that post to mark it.  This gives the posters credit for the help and lets other members know what worked.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.