Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

"And" instead of "Or" in set analysis

Hello,

I am attempting to use set analysis to indentify customers who have orders in two specfic statuses. I know how to make status one or another. I would like to make the set only include those that have "delayed" and "pending" order statuses (multiple orders). Is there a way I can do this?

Here is what I have so far....

Count({$<Status={"delayed","pending"}>}Distinct Customer_id)

Thanks,

Jeff

Tags (2)
2 Replies
MVP
MVP

Re: "And" instead of "Or" in set analysis

Try

=count({$<Customer_id = p({<Status={delayed}>})*p({<Status = {pending}>}) >} distinct Customer_id)

Re: "And" instead of "Or" in set analysis

Also try this

Count({$<Status={"delayed"}>*$<Status={"pending"}>}Distinct Customer_id)