Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
segerchr
New Contributor III

Set analysis and/or/and-or

Hey,

when i want "and" i will write: count({1<Test={'x'},Test2={'x'} >}TerminID)

when i want "or" i will write: count({1<Test={'x'}>+<Test2={'x'} >}TerminID)

how can i write: count({1<Test3={'x'} "and" (Test2={'x'} or Test2={'x'} )>}TerminID)

Thanks for helping

CS

2 Replies

Re: Set analysis and/or/and-or

May be this:

Count({1<Test3={'x'}, Test={'x'}>+1<Test3={'x'}, Test2={'x'} )>}TerminID)

mov
Esteemed Contributor III

Re: Set analysis and/or/and-or

Or:

Count({1<Test3={'x'}> * (1<Test={'x'}> + 1<Test2={'x'}> )} TerminID)