Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Intersection in Alternate States.

Dear ALL,

Greetings for the day!!!

I have an issue in Alternate Issues for finding the Intersection.

Scenario:

State A:  Based on the selection of Products with >= Sales Value, the customers are listed.

State B: Based on the selection of Products with <= Sales Value, the customers are listed.

Now we need to have the common customers in both the states.

For Ex:

From the attachment,

Selecting Product 1, DALL,

Cust20000      DALL     11700

Selecting Product 2, OIL & RICE,

Cust10000     OIL      1400

Cust20000     OIL      5900

Cust10000     RICE     10300

NOw my result should be,

Cust20000     DALL     11700

Cust20000     OIL          5900

I am trying with,

=Sum({yes + no <Sales=P({<CustomerName = no::CustomerName>})>}Sales)

NOTE: yes & no is Alternate States.

Also attached the InputFile & my workings QVW file.

Please help me out.

1 Reply
swuehl
MVP
MVP

Please try to avoid duplicate postings. I've attached a suggested solution to your other thread.

Intersection in Alternate States