Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mikegauntlett
Contributor III
Contributor III

Count

Hi Guys,

I have a requirement to be able to count the number of Orders where two conditions occur.

for Instance

the Number of Orders 'POMS' where the below conditions occur.

sum(IF(OF_PA_Status='Approved by Customer',(IF(MSTATUS='R4',1,0)),0))

so I am thinking

Count([POM](IF(OF_PA_Status='Approved by Customer',(IF(MSTATUS='R4',1,0)),0))

Would this work ? as a measure in the app, not in the script as a expression.

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Or may be this

Count({<POM = {"=OF_PA_Status = 'Approved by Customer' and MSTATUS = 'R4'"}>} [POM])

View solution in original post

3 Replies
Anonymous
Not applicable

Maybe use Set Analysis :

Count ( {<      [OF_PA_Status]      = {'Approved by Customer'}

                      [MSTATUS]             = {'R4'} >}

                              [POM] )


Note:  Above typed freehand so may well have a typo in it.

Digvijay_Singh

May be this -

Count({<OF_PA_Status={'Approved by Customer'},MSTATUS={'R4'}>}[POM])

sunny_talwar

Or may be this

Count({<POM = {"=OF_PA_Status = 'Approved by Customer' and MSTATUS = 'R4'"}>} [POM])