topic Re: Count multiple condition in App Development

Count multiple condition

busralisan — Sat, 17 Dec 2022 21:05:13 GMT

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?

Re: Count multiple condition

MarcoWedel — Sat, 17 Dec 2022 21:47:31 GMT

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-operators.htm#:~:text=%2B,two%20set%20operands.

Re: Count multiple condition

AronC — Sat, 17 Dec 2022 22:42:54 GMT

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.

Re: Count multiple condition

vinieme12 — Mon, 19 Dec 2022 08:09:44 GMT

as below

count({<

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

,otherCondition1

,otherCondition2

>} [QueueItemId])

Re: Count multiple condition

busralisan — Tue, 20 Dec 2022 05:58:35 GMT

Thank you so much!