Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

chiru_thota
Valued Contributor

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
MVP
MVP

Re: Set analysis help

Try with intersection operator *

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

1 Reply
MVP
MVP

Re: Set analysis help

Try with intersection operator *

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