Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ganeshreddy
Not applicable

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
sunny_talwar
Not applicable

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


2 Replies
sunny_talwar
Not applicable

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


Gysbert_Wassenaar
Not applicable

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