Count multiple condition

[busralisan]

Hello,

I need mutliple condition in count function like this:

count({<[QueueItemStatus]={'3'} or [ProcessingExceptionType]=1,Group=P(QueueCreationDate)>} [QueueItemId])

But this "or" is not correct? How can I use or in count dunction?

[MarcoWedel]

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn....

[AronC]

Try

count({(<[QueueItemStatus]={'3'} >+<[ProcessingExceptionType]=1>)*<Group=P(QueueCreationDate)>} [QueueItemId])

It doesn't say from you expression in what order you would like to perform your operations. Just change the parenthesis to whatever suit your needs. In this expression there is first a union (to replace your "or-statement" between status and type and then everything is in an intersection with date. 

[vinieme12 · Accepted solution]

as below

count({<

QueueItemId  =p({< [QueueItemStatus]={3} >+<[ProcessingExceptionType]={1}>} QueueItemId)

,otherCondition1

,otherCondition2

>} [QueueItemId])

[busralisan]

Thank you so much!