topic Find values that contains.. in QlikView

Find values that contains..

nicolai_moller — Wed, 01 May 2013 08:53:03 GMT

Hello

I have a list of operations and each operation have one or more states during a time period

Ex.

Operation:

Alpha

Bravo

Charlie

States:

I want to make a list of operations that contains State 1 and 2, even if they have had other states, ex. 3 and/or 4 also.

Thanks

Re: Find values that contains..

Gysbert_Wassenaar — Wed, 01 May 2013 09:05:49 GMT

I assume you want to operations that have both state 1 and state 2. Use Operation as dimension in a straight chart object and as expression sum({<States={1},Operation=p({<States={2}>}Operation)>} 1). You can hide the expression on the Presentation tab of the properties window. Replace States and Operation with your exact field names.