topic Re: Two Condition in Text Object Expression in QlikView

Two Condition in Text Object Expression

Tue, 06 Aug 2013 08:58:22 GMT

Dear all,

I have the following code in the expression..

= SUM({$<b_UserDeptSection={'MACHINE LINE'}>} b_IndirectHours)

What is the best method to select the userdeptsection = 'NON MACHINE LINE' as well? My current solution as below

SUM({$<b_UserDeptSection={'MACHINE LINE'}>} b_IndirectHours) + SUM({$<b_UserDeptSection={'NON MACHINE LINE'}>} b_IndirectHours)

May i know is the SUM function will take in 2 condition for example (b_UserDeptSection= {'MACHINE LINE'} or b_UserDeptSection= {'NON MACHINE LINE'})??

Thank you

Re: Two Condition in Text Object Expression

MayilVahanan — Tue, 06 Aug 2013 09:00:22 GMT

Try like this

= SUM({$<b_UserDeptSection={'MACHINE LINE', 'NON MACHINE LINE' }>} b_IndirectHours)

Hope that helps

Re: Two Condition in Text Object Expression

Tue, 06 Aug 2013 09:05:58 GMT

Thanks Mayil.

What about the 2 condition referring to different field?

one is b_UserDeptSection='MACHINE LINE'

and

b_UserAge>18

how do we put in a single SUM statement?

Re: Two Condition in Text Object Expression

Tue, 06 Aug 2013 09:12:07 GMT

Hi,

= SUM({$<b_UserDeptSection={'MACHINE LINE'}, b_UserAge ={'>18'}>} b_IndirectHours)

Re: Two Condition in Text Object Expression

MayilVahanan — Tue, 06 Aug 2013 09:12:22 GMT

Try like this

=SUM({$<b_UserDeptSection={'MACHINE LINE'} , b_UserAge ={">18"} >} b_IndirectHours)

Hope that helps