Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
ganeshreddy
Contributor III

Multiple Value trace?

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

1 Solution

Accepted Solutions

Re: Multiple Value trace?

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:

Capture.PNG


View solution in original post

2 Replies

Re: Multiple Value trace?

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:

Capture.PNG


View solution in original post

MVP & Luminary
MVP & Luminary

Re: Multiple Value trace?

Perhaps you can use the Exists function:

LOAD

     C_No,

     D_No,

     Grade,

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

FROM ...


talk is cheap, supply exceeds demand