Error in set modifier expression in count with multiple conditions

[BaNANA]

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?

[usamabinsadiq]

Hi,

please try this:

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

I hope this helps.

Regards, 

[BaNANA]

I tried this but same error as original. 

[Brett_Bleess]

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

[Saravanan_Desingh]

Try this.

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

[Brett_Bleess]

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