topic Re: Multiple Value trace? in QlikView

Multiple Value trace?

ganeshreddy — Wed, 27 May 2015 13:09:39 GMT

Hi All,

How to find multiple values in a specific field in script, as mentioned below.

C_No D_No Grade

23125 2345 A

45689 2345 C

89089 4568 A

32576 2345 B

90976 1234 C

In the above table D_No repeated 3 times, here how to identify the repetition. If it is repeated i need to perform some operations. Please help me on this.

Cheers,

Ganesh

Re: Multiple Value trace?

sunny_talwar — Wed, 27 May 2015 13:23:29 GMT

Try this script:

Table:

LOAD * INLINE [

C_No, D_No, Grade

23125, 2345, A

45689, 2345, C

89089, 4568, A

32576, 2345, B

90976, 1234, C

];

Join(Table)

LOAD D_No,

Count(D_No) as Count

Resident Table

Group By D_No;

Output:

Re: Multiple Value trace?

Gysbert_Wassenaar — Wed, 27 May 2015 13:24:41 GMT

Perhaps you can use the Exists function:

LOAD

C_No,

D_No,

Grade,

if(Exist(D_No), 0, 1) as IsNew

FROM ...