Is it possible Multiple Set Analysis in one Expres... - Qlik Community

Report Inappropriate Content · ‎2011-10-11

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 · ‎2011-10-11

see the following

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

Year=>

}>}RequestID)

hope this help

Sunil Chauhan

kaushiknsolanki · ‎2011-10-11

Hi,

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

Regards,

Kaushik Solanki

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

Is it possible Multiple Set Analysis in one Expression?