Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

Exp not working

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?

Tags (2)
11 Replies
prma7799
Honored Contributor III

Re: Exp not working

I think you missed else part ..

soniasweety
Valued Contributor III

Re: Exp not working

No,

ID is else part

its there  'Not',[ID])

prma7799
Honored Contributor III

Re: Exp not working

Then you should use here aggregate function

Try this..

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

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

soniasweety
Valued Contributor III

Re: Exp not working

no PM.

it will give me the  1,1,1,1  like that  but I want to see that value    count it will not work

Re: Exp not working

Only returns only one values has been allocate else it will return Null. So, To over come this, Perhaps this may do job

if(Count(Aggr(only({<JNum={">=$(=vStartDate)<=$(=vEndDate)"},[RC]={'IN'},[Inl]={'Out'}>} [ID]), Field))=0,'Not',[ID])

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
soniasweety
Valued Contributor III

Re: Exp not working

its not working anil,

Re: Exp not working

Yes, I know that . Where are you trying this? As i already stated it should not be Only. Can you explain your needed?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
soniasweety
Valued Contributor III

Re: Exp not working

hmm,

I am using same exp in  kpi object its working

when its come to   straight table its not working.

Re: Exp not working

You have to cover all Dimension to aggregate functions like

if(Count(Aggr(only({<JNum={">=$(=vStartDate)<=$(=vEndDate)"},[RC]={'IN'},[Inl]={'Out'}>} [ID]), Dim1, Dim2, Dim3))=0,'Not',[ID])

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)