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: 
Anonymous
Not applicable

Less than and Greater than in QlikView

Hi,

I would like to ask how can I add another condition as I was trying to

1) Count the number of Active  Item

then

2) If it's less than 12 but greater than 0 it should show Complete

if not it should show In Progres.

This expression works, but it shows in progress for 0

= IF(Num(Count( {<[Active Status]={'Active'}>}[ItemName]),'####')<12,'In Progress','Complete')

I hope you would help me.

Thanks.

2 Replies
m_woolf
Master II
Master II

= IF(Num(Count( {<[Active Status]={'Active'}>}[ItemName]),'####')<12

and Num(Count( {<[Active Status]={'Active'}>}[ItemName]),'####')>0,'In Progress','Complete')

Anonymous
Not applicable
Author

Thanks