topic Is it possible Multiple Set Analysis in one Expression? in QlikView

Is it possible Multiple Set Analysis in one Expression?

Tue, 11 Oct 2011 06:52:38 GMT

Hi All,

Good Day...

I have two expression as given below to display records on Straight Table.

Expression1:

=count( {$<Status={'Complete'}, Year={$(vYear)}>}RequestID)

Expression2:

=count( {$<Status={'In Progress','Unknown'}, Year=>}RequestID)

Can we make this into one expression instead of two expression?. Here this expression going to hide, so no problem to value and all.

Any suggestion are welcome...Thanks.

Thanks

Gangadharan M

SunilChauhan — Tue, 11 Oct 2011 06:56:58 GMT

see the following

=count( {$<Status={'Complete','In Progress','Unknown'}, Year={$(vYear),

Year=>

}>}RequestID)

hope this help

kaushiknsolanki — Tue, 11 Oct 2011 07:05:19 GMT

Hi,

Did you try the answer i gave you on this post.

Regards,

Kaushik Solanki