topic Re: Error in set modifier expression in count with multiple conditions in QlikView

Error in set modifier expression in count with multiple conditions

BaNANA — Thu, 09 Apr 2020 01:43:37 GMT

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?

Re: Error in set modifier expression in count with multiple conditions

usamabinsadiq — Thu, 09 Apr 2020 02:07:21 GMT

Hi,

please try this:

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

I hope this helps.

Regards,

Re: Error in set modifier expression in count with multiple conditions

BaNANA — Thu, 09 Apr 2020 02:23:25 GMT

I tried this but same error as original.

Re: Error in set modifier expression in count with multiple conditions

Brett_Bleess — Wed, 29 Apr 2020 17:45:00 GMT

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/SetAnalysis/set-analysis-expressions.htm

Regards,
Brett

Re: Error in set modifier expression in count with multiple conditions

Saravanan_Desingh — Fri, 01 May 2020 00:33:23 GMT

Try this.

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

Re: Error in set modifier expression in count with multiple conditions

Brett_Bleess — Tue, 12 May 2020 14:58:54 GMT

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