Exp not working

[soniasweety]

Hi all,

I am using below expression its showing ok but the result is not coming.

if(only({<JNum={">=$(=vStartDate)<=$(=vEndDate)"},

[RC]={'IN'},[Inl]={'Out'}>} [ID])=0,'Not',[ID])

but  if I use this  its working fine enough

only({<JNum={">=$(=vStartDate)<=$(=vEndDate)"},

[RC]={'IN'},[Inl]={'Out'}>} [ID]) 

if I  add the  IF condition its not working  what is the issue?

[prma7799]

This will help you ...

Aggr - chart function ‒ QlikView

[praveenkumar_ma]

Try this---

Count(only({<JNum={'>=$(=vStartDate)<=$(=vEndDate)'},

[RC]={'IN'},[Inl]={'Out'}>} [ID])=0,'Not',[ID])