Less than and Greater than in QlikView

[Anonymous]

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.

[m_woolf]

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

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

[Anonymous]

Thanks