topic Re: Multiple conditions in a field using IF clause in QlikView

Multiple conditions in a field using IF clause

Fri, 30 Aug 2013 05:40:23 GMT

I have to check the following condition in my requirement

=Count( Distinct if( StageID =7 or StageID=8 or StageID=9 ,UserID))

Is there any way to handle the above condition like we do in sql : StageID in (7,8,9) in my IF condition.

MayilVahanan — Fri, 30 Aug 2013 05:42:29 GMT

Try like this

= Count({<StageID = {7,8,9}>} Distinct UserID)

=Count( Distinct if( match(StageID,7,8,9) ,UserID))

tresB — Fri, 30 Aug 2013 05:42:44 GMT

Try match() function. In general multiple ORs should be better handled by match().

CELAMBARASAN — Fri, 30 Aug 2013 05:43:32 GMT

For this type of requirement you have to go with set analysis.

Count( {<StageID ={7,8 ,9}>} Distinct UserID)

Hope it helps

Celambarasan

Fri, 30 Aug 2013 05:45:37 GMT

I want to use it in an expression is that possible?

Fri, 30 Aug 2013 05:46:27 GMT

I have other conditions to check too.Without using set analysis is there any other option??