Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
sivakumar01
Contributor III
Contributor III

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

Accepted Solutions
tresesco
MVP
MVP

9 Replies
Not applicable

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

Hi Siva,

Try like this in Text object

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

Regards,

Jagan.

sivakumar01
Contributor III
Contributor III
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)

tresesco
MVP
MVP

sivakumar01
Contributor III
Contributor III
Author

Hi Tresesco,

Thanks for help Its Working fine.

Thanks & Regards,

Sivakumar