topic Re: Calcuate the repeated values in QlikView

Calcuate the repeated values

Anonymous — Fri, 11 Jul 2014 06:49:14 GMT

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

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

Can any one help on this

Thanks & Regards,

Sivakumar

Re: Calcuate the repeated values

Fri, 11 Jul 2014 06:52:16 GMT

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

Re: Calcuate the repeated values

sasikanth — Fri, 11 Jul 2014 06:58:28 GMT

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,

Re: Calcuate the repeated values

maxgro — Fri, 11 Jul 2014 07:13:15 GMT

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)

load rowno()as id, field;

load * inline [

field

S001

S002

S001

S003

];

see attachment for different (easier) solution with a chart

Re: Calcuate the repeated values

tresB — Fri, 11 Jul 2014 07:21:43 GMT

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

PFA

Note: This would work for mutiple values as well.

Re: Calcuate the repeated values

jagan — Fri, 11 Jul 2014 07:44:34 GMT

Hi Siva,

Try like this in Text object

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

Regards,

Jagan.

Re: Calcuate the repeated values

Anonymous — Fri, 11 Jul 2014 08:00:46 GMT

Hi Tresesco,

Iam Not able to open the file.

Thanks & Regards,

Sivakumar

Re: Calcuate the repeated values

its_anandrjs — Fri, 11 Jul 2014 08:06:55 GMT

Try this way also i explain with your sample data

Ex:_

LOAD * INLINE [

String

S001

S002

S001

];

And on the Text object write expression

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

Re: Calcuate the repeated values

tresB — Fri, 11 Jul 2014 08:11:02 GMT

Re: Calcuate the repeated values

Anonymous — Mon, 14 Jul 2014 06:02:49 GMT

Hi Tresesco,

Thanks for help Its Working fine.

Thanks & Regards,

Sivakumar