Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
chauhans85
Esteemed Contributor

Is it possible Multiple Set Analysis in one Expression?

see the following

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

Year=>

}>}RequestID)

hope this help

Is it possible Multiple Set Analysis in one Expression?

Hi,

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

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

Regards,

Kaushik Solanki

Community Browser