topic Re: expression in edit script in QlikView

expression in edit script

Fri, 26 Aug 2011 08:50:06 GMT

Hi everyone,

I am trying to achieve is " if any one 'Fail' occurs in an LensKey then the StatusField should be 'FAIL' " and also see the attached script document.

I Used below line in edit script, it is not getting the correct result . Can you suggest the correct solution to get this.

if(sum([Status EdgeChips1])>=3,'Fail',if(sum([Status EdgeChips1])>=1,'Pass','NA')) as [Status EdgeChips]

The below is the sample example.

Ex1

LensKey, DefectStatus

1, Fail

1,Pass

1,-

For this ex1 , the result should be = Fail

Ex2:

LensKey, DefectStatus

2, Pass

2,Pass

2,-

For this ex2 , the result should be = Pass

Ex3

LensKey, DefectStatus

3,Fail

For this ex3 , the result should be = Fail

Ex4

LensKey, DefectStatus

4,-

For this ex4 , the result should be = NotAvailable.

Thanks in advance

expression in edit script

Fri, 26 Aug 2011 09:14:56 GMT

How about assigning a number to each type so that

LOAD

LensKey,

DefectStatus,

If(DefectStatus='Fail',5,If(DefectStatus='Pass,1,0)) as DefectValue

1 as Rec_Count

then in the display you can put logic in which says

If(sum(DefectValue>3,'Fail','Pass') as DisplayValue

or if more than three records then

If(Sum(DefectValue)/sum(Rec_Count)>1'Fail','Pass')

hope this helps

expression in edit script

lkallioniemi — Fri, 26 Aug 2011 11:41:05 GMT

Hi,

have you tried max-function?

left Join (Summarized)

LOAD LensKey,

COUNT(CountDefectEdgeChip) as EdgeChipCountPerLens,

if(max([Status EdgeChips1])=2,'Fail',if(max([Status EdgeChips1])=1,'Pass','NA')) as [Status EdgeChips]

Resident Summarized

Group by LensKey;

Lasse

Re: expression in edit script

Fri, 26 Aug 2011 12:42:21 GMT

Hi Ikallioniemi,

Thanks you very much,

It was awesome, and works fine in my application.

Regards

Re: expression in edit script

Sat, 27 Aug 2011 11:37:11 GMT

Hi ikallioniemi,

How can i count number of fails and pass in the each Lenskey.

If Pass or Fail is not available for particular LensKey, then it should display 0.

I need to place below to [Status EdgeChips], below code you provided for placing the 'Fail' or 'Pass'

left Join (Summarized)

LOAD LensKey,

COUNT(CountDefectEdgeChip) as EdgeChipCountPerLens,

if(max([Status EdgeChips1])=2,'Fail',if(max([Status EdgeChips1])=1,'Pass','NA')) as [Status EdgeChips],

//Here i need to place line for PassEdgeChips,

//Here i need to place line for FailEdgeChips

Resident Summarized

Group by LensKey;

Ex1

LensKey, DefectStatus

1, Fail

1,Pass

1,-

For this ex1 , the result should be PassEdgeChips=1, FailEdgeChips=1

Ex2:

LensKey, DefectStatus

2, Pass

2,Pass

2,-

For this ex2 , the result should be PassEdgeChips=2, FailEdgeChips=0

Ex3

LensKey, DefectStatus

3,Fail

For this ex3 , the result should be PassEdgeChips=0, FailEdgeChips=3

Ex4

LensKey, DefectStatus

4,-

For this ex4 , the result should be PassEdgeChips=0, FailEdgeChips=0

How can i work on this ?

Thanks in Advance.

expression in edit script

lkallioniemi — Wed, 31 Aug 2011 07:26:07 GMT

Hi,

this should do the trick:

Sum(if([Status EdgeChips1]=2,1,0))= as FailEdgeChips,

Sum(if([Status EdgeChips1]=1,1,0))= as PassEdgeChips,

Lasse