COUNT with multiple conditions

[Anonymous]

Hello,

I have the following expression:

COUNT ({$<[Progress]={'Started','On hold','Completed'} , [Current Phase]={'Plan','Execute','Close'}, [Global]={'On Track'} > } [Project NAME])

The COUNT returns  0 instead of 25.

Actually on my table I have multiple rows with:

- only the value 'Started' for  'Progress'

- only the value  'Execute' for 'Current phase'

I think this is the reason.

The first Expression is :

COUNT ({$< [Global]={'On Track'} > } [Project NAME])

Its returning 11.

Thanks in advance for your help.

[Anonymous]

Maybe your Current Phase is not a text field, u can try this test?

Count({$<[Progress]={'Started','On hold','Completed'} , [Global]={'On Track'} > }[Project NAME])

[Anonymous]

Yes no problem in Database and data is well loaded in Qlikview

[stabben23]

Ok, then Uncheck "Enable" checkbox and try With only this Expression.

[Anonymous]

[sunny_talwar]

I am seeing 5

[Anonymous · Accepted solution]

Now It is working.

I deleted Current Phase column in my Excel file, and created it from scratch!

[Anonymous]

Now It is working.

I deleted Current Phase column in my Excel file, and created it from scratch!