Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is it possible Multiple Set Analysis in one Expression?

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

2 Replies
SunilChauhan
Champion
Champion

see the following

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

Year=>

}>}RequestID)

hope this help

Sunil Chauhan
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

http://community.qlik.com/message/156284#156284

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!