Calcuate the repeated values

[Anonymous]

Hi All,

  iam new to qlikview ,currently i have a problem.i want to find the repeated values and print in the text object.

For example:

           S001

           S002

           S001

           S001

Now i want to print data in the Text object as  S001  = 3

Can  any  one  help on this

Thanks & Regards,

Sivakumar

[#2]

=Count({<Field={'S001'}>} Field)

[sasikanth]

HI siva

Take this field in list box and check the checkbox Show Frequency

then you will get a values beside it how many times it is repeated,

[maxgro]

if you have more than one duplicate, in a textbox maybe

=concat(if(aggr(count(field),field)>1, aggr(field & ' = ' & count(field),field) ), chr(10), field)

t:

load rowno()as id, field;

load * inline [

field

S001

S002

S001

S001

S003

S003

];  

see attachment for  different (easier) solution with a chart

[tresesco]

='Repeated  :'&Concat(If(Aggr(Count(Field),Field)>1, Field&' Count :'&Aggr(Count(Field),Field)), '|')

PFA

Note: This would work for mutiple values as well.

[jagan]

Hi Siva,

Try like this in Text object

=Concat(Aggr(If(Count(field) > 1,field & '=' & Count(field)), field), ',')

Regards,

Jagan.

[Anonymous]

Hi Tresesco,

Iam Not able to open the file.

Thanks & Regards,

Sivakumar

[its_anandrjs]

Try this way also i explain with your sample data

Ex:_

LOAD * INLINE [

    String

    S001

    S002

    S001

    S001

];

And on the Text object write expression

=GetFieldSelections(String)  &'   =   '&Count(String)

[tresesco · Accepted solution]

[Anonymous]

Hi Tresesco,

Thanks for help Its Working fine.

Thanks & Regards,

Sivakumar