Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calcuate the repeated values

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

1 Solution
9 Replies
Not applicable
Author

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

sasikanth
Master
Master


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,

untitled.png

maxgro
MVP
MVP

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
MVP
MVP

='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
Luminary Alumni
Luminary Alumni

Hi Siva,

Try like this in Text object

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

Regards,

Jagan.

Anonymous
Not applicable
Author

Hi T

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)

Anonymous
Not applicable
Author

Hi Tresesco,

Thanks for help Its Working fine.

Thanks & Regards,

Sivakumar