Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist 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
Highlighted
Master III
Master III

Re: Exp not working

I think you missed else part ..

Highlighted
Specialist III
Specialist III

Re: Exp not working

No,

ID is else part

its there  'Not',[ID])

Highlighted
Master III
Master 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]))

Highlighted
Specialist III
Specialist 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

Highlighted

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)
Highlighted
Specialist III
Specialist III

Re: Exp not working

its not working anil,

Highlighted

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)
Highlighted
Specialist III
Specialist 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.

Highlighted

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)