Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
fernandosanchez
Contributor II
Contributor II

Count if two conditions

Hi all,

I'm trying to make a count of a set of projects with two conditions: if the Projects are in progress (InProgress = 1) and the Duration is greater than 99.

I'm using this expression: 

count({ <Duration={'>99'}, InProgress={'1'}>} InProgress)

But the result is showing me 0...

 

Can you guys please help me?

Thank you!

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

@fernandosanchez expression looks fine to me. try using double quotes as you are using search string in set

count({ <Duration={">9"}, InProgress={'1'}>} InProgress)

View solution in original post

3 Replies
Kushal_Chawda

@fernandosanchez expression looks fine to me. try using double quotes as you are using search string in set

count({ <Duration={">9"}, InProgress={'1'}>} InProgress)

Prem0212
Creator
Creator

its showing zero means there is no relatable data for that combination so that the used expression is correct. If the expression is incorrect it will show the blank value
fernandosanchez
Contributor II
Contributor II
Author

This fixed it, many thanks!😀 @Kushal_Chawda