topic Re: Error in Expression in QlikView

Error in Expression

Thu, 01 Oct 2015 06:38:16 GMT

Could some one rectify this expression , it is not executing.

=Count(if([P ID]='1',([Review Name]='ECO1' , [Review Decision]<>'Pass') and

if([P ID]='2',([Review Name]='ECO2', [Review Decision]<>'Pass'),PRJ_ID)))

need to count PRJ_ID based on theses conditions [P ID]='1',([Review Name]='ECO1' , [Review Decision]<>'Pass'

Thanks

Re: Error in Expression

tamilarasu — Thu, 01 Oct 2015 06:53:06 GMT

Hi Vamsi,

Try this,

=Count({<[P ID]={'1','2'},[Review Name]={'ECO1','ECO2'} , [Review Decision]=-{'Pass'}>} PRJ_ID)

Re: Error in Expression

Anonymous — Thu, 01 Oct 2015 06:58:09 GMT

Try this

=Count({<PID={'1'},ReviewDecision-={'PASS'},ReviewNAme={'EC01'}>}PRJ_ID)

Re: Error in Expression

Thu, 01 Oct 2015 07:00:46 GMT

Try this below Set analysis Expression I hope this will works..

=Count({<[P ID]={'1'},[Review Name]={'ECO1'},notMatch([Review Decision],'Pass')>}PRJ_ID)

Re: Error in Expression

Kushal_Chawda — Thu, 01 Oct 2015 07:24:05 GMT

try

=Count({<[P ID]={'1'},[Review Name]={'ECO1'} , [Review Decision] - ={'Pass'}> * <[P ID]={'2'},[Review Name]={'ECO2'} , [Review Decision] - ={'Pass'}>} PRJ_ID)

Re: Error in Expression

jonathandienst — Thu, 01 Oct 2015 07:27:31 GMT

Kush141087:

=Count({<[P ID]={'1'},[Review Name]={'ECO1'} , [Review Decision] - ={'Pass'}> * <[P ID]={'2'},[Review Name]={'ECO2'} , [Review Decision] - ={'Pass'}>} PRJ_ID)

I agree, except that you need a union rather than an intersection:

=Count({<[P ID]={'1'},[Review Name]={'ECO1'} , [Review Decision] -={'Pass'}> + <[P ID]={'2'},[Review Name]={'ECO2'} , [Review Decision] -={'Pass'}>} PRJ_ID)

(and no spaces between the - and = for the -= operator)

Re: Error in Expression

Thu, 01 Oct 2015 08:51:55 GMT

Thankyou Jonathan