Set analysis help

chiru_thota — Mon, 26 Jan 2026 18:19:17 GMT

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:

Screen 2:

Re: Set analysis help

swuehl — Tue, 28 Jan 2014 21:55:14 GMT

Try with intersection operator *

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