Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted
Contributor III
Contributor III

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

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.
Highlighted
Contributor
Contributor

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

I tried this but same error as original. 

Highlighted
Digital Support
Digital Support

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

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.
Highlighted
Specialist III
Specialist III

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

Try this.

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

 

Highlighted
Digital Support
Digital Support

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

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.