topic Re: Exp not working in QlikView

Exp not working

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Exp not working

prma7799 — Fri, 22 Dec 2017 05:44:35 GMT

I think you missed else part ..

Re: Exp not working

soniasweety — Fri, 22 Dec 2017 05:47:09 GMT

No,

ID is else part

its there 'Not',[ID])

Re: Exp not working

prma7799 — Fri, 22 Dec 2017 05:52:37 GMT

Then you should use here aggregate function

Try this..

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

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

Re: Exp not working

soniasweety — Fri, 22 Dec 2017 05:55:09 GMT

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

Anil_Babu_Samineni — Fri, 22 Dec 2017 06:00:21 GMT

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])

Re: Exp not working

soniasweety — Fri, 22 Dec 2017 06:08:14 GMT

its not working anil,

Re: Exp not working

Anil_Babu_Samineni — Fri, 22 Dec 2017 06:09:40 GMT

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

Re: Exp not working

soniasweety — Fri, 22 Dec 2017 06:14:03 GMT

hmm,

I am using same exp in kpi object its working

when its come to straight table its not working.

Re: Exp not working

Anil_Babu_Samineni — Fri, 22 Dec 2017 06:15:47 GMT

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])

Re: Exp not working

prma7799 — Fri, 22 Dec 2017 06:25:38 GMT

This will help you ...

Aggr - chart function ‒ QlikView

Re: Exp not working

praveenkumar_ma — Mon, 04 Jun 2018 12:30:35 GMT

Try this---

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

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