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: 
chiru_thota
Specialist
Specialist

Set analysis help

Hi All,

We have a metric to show only closed Orders and we have implemented set analysis with filter.

Now the issue is with selection.When user selects some other status ,Orders Closed always showing data.

Example : In below screen user selected Status = Open.But report showing other status also as we have Orders Closed metric.

is there anyway to get output as shown in screen2 and still having filter on Status=Closed for Orders Closed metric;

I have attached QVW also.

Screen 1:

IImage 12.jpg

Screen 2:

Image 14.jpg

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try with intersection operator *

sum({<Status*= {'Closed'}>}Orders)

View solution in original post

1 Reply
swuehl
MVP
MVP

Try with intersection operator *

sum({<Status*= {'Closed'}>}Orders)