Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ptl14495
Contributor III
Contributor III

Count if

Hi,

I have a table with two fields i want to use as a condition to count the number of orders that fulfill that condition.

Something like,

If ( Actual Response Time > Contractual Response time, Count ( Order No ), if not don't count )

I am not confortable doing it in script so i need a solution if possible, as an expression.

thank you

Fernando Rodrigues

15 Replies
ptl14495
Contributor III
Contributor III
Author

that is what i see. meanning, i have the same result with the formulas  (the count of order is just for you to have an idea of the total)

thank you

Chanty4u
MVP
MVP

add a stright table with all the fields which you have used and see which value is greater or less

sunny_talwar

Can you share an image of your data model?

ptl14495
Contributor III
Contributor III
Author

here it is.

the field i am using are from one table only and need no connection with other tables.

data model.JPG

sunny_talwar

Oh so they all come from the same table? Is it possible that all Order No_ meet the condition? Can you check this by creating a table like this

Dimensions

Order No_

Actual Response Time (Hours)

Response Time

Measure

[Actual Response Time (Hours)] > [Response Time]

and see if you are seeing  any 0s or not?

ptl14495
Contributor III
Contributor III
Author

You're absolutely right!

i was connecting the wrong field!

I'll get back on this if i get no luck with any of your suggestions.

My apologies.

thank you!