Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Champion
Champion

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

Highlighted
MVP & Luminary
MVP & Luminary

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".