topic Re: count repeated value in QlikView

count repeated value

sagarrahul — Wed, 25 Nov 2020 16:16:04 GMT

hii need a help

just tell me how to count repeated value in below table .

ICD_CODE_LEVEL1_org

N41.0

R50.9

B54

S82.1

B54

plesase help me in this

Re: count repeated value

sunny_talwar — Fri, 17 Jun 2016 11:42:56 GMT

In script? or front end?

Re: count repeated value

Kushal_Chawda — Fri, 17 Jun 2016 11:43:11 GMT

what is expected output?

Re: count repeated value

sagarrahul — Fri, 17 Jun 2016 11:47:16 GMT

in expression

Re: count repeated value

sagarrahul — Fri, 17 Jun 2016 11:49:12 GMT

this i want my output

ICD_CODE_LEVEL1_org	output
N41.0	3
N41.0	3
N41.0	3
R50.9	3
R50.9	3
R50.9	3
B54	3
B54	3
S82.1	1
B54	3

Re: count repeated value

elakkians — Fri, 17 Jun 2016 11:52:34 GMT

Hi,

If its Front end Formula you can use

'=if(Count(test)>1,Count(DISTINCT test))'

if you need to do in script plz check the demo app which i have attached. !

Re: count repeated value

MK_QSL — Fri, 17 Jun 2016 11:53:09 GMT

Something like this?

Re: count repeated value

sunny_talwar — Fri, 17 Jun 2016 11:53:12 GMT

Why do you want the ICD_CODE_LEVEL1_org to be repeated? Why not this?

ICD_CODE_LEVEL1_org	output
N41.0	3
R50.9	3
S82.1	1
B54	3

If the above work, then this should do it:

Dimension: ICD_CODE_LEVEL1_org

Expression: Count(ICD_CODE_LEVEL1_org)

Re: count repeated value

sagarrahul — Fri, 17 Jun 2016 11:54:18 GMT

i want just output bro

Re: count repeated value

sagarrahul — Fri, 17 Jun 2016 11:55:48 GMT

sunny thanks for ur help n time

but this ICD_CODE_LEVEL1_org are given in wildmatch then how to count repeated values

Re: count repeated value

sunny_talwar — Fri, 17 Jun 2016 11:56:00 GMT

Look at Manish's response above. He has the exact thing you want

Re: count repeated value

sunny_talwar — Fri, 17 Jun 2016 11:56:40 GMT

May be like this:

Sum(If(WildMatch(ICD_CODE_LEVEL1_org, .....), 1, 0)

Re: count repeated value

sagarrahul — Fri, 17 Jun 2016 12:03:32 GMT

sunny i want this in wildmatch values

('T02.9','T02.8','T02.7','T02.6','T02.5','T02.4','T02.3','S43.3','S43.2','S43.1','S43.0','S42.9','S42.8','S42.7','S42.4','S42.3','S42.2',

'S42.1','S42.0','S62.8','S62.7','S62.6','S62.5','S62.4','S62.3','S62.2','S62.1','S62.0','S22.8','S22.5','S55.9','S55.8','S55.7','S55.1','S55.0','S32.7','S32.5','S32.4',

'S32.3','S32.2','S32.1','S32.0','S52.4','S52.3','S52.2','S52.1','S52.0','S93.2','S92.9','S92.7','S92.5','S92.4','S92.3','S92.2','S92.1','S92.0','S02.9','S02.8','S02.7',

'S02.6','S02.5','S02.4','S02.3','S02.2','S02.1','S34.1','T93.2','T90.2','T90.0','B97.3','S65.2','S65.0','S45.1','S45.0','S44.8','S44.7','S44.4','S44.3','S44.2','S44.1',

'S44.0','S82.7','S82.6','S82.5','S82.4','S82.3','S82.2','S82.1','S82.0','T93.1','T92.9','T92.8','T92.5','T92.4','T92.3','S59.7','A18.0','S64.2','S64.1','S64.0','S23.1',

'S22.9','S54.9','S54.8','S54.7','S54.2','S54.1','S54.0','S53.1','S53.0','S52.9','S52.8','S52.7','S52.6','T10','M45','T12','T08','S52.5','S89.7','T92.2','T92.1','S73.1',

'S73.0','S72.9','S72.8','S72.7','S72.4','S72.3','S72.2','S72.1','S33.2','S33.1','S22.1','S22.0','S22.4','S22.3','S22.2','Q66.1','Q66.0','M96.6','M84.3','M84.2','M84.1',

'M84.0','M20.1','M67.4','M54.5','M54.3','M01.1 ','M01.0 ','M00.9','M51.9','M51.8','M51.3','M51.2','M51.1','M51.0','M46.2','M49.0 ','M23.0','M25.7','M25.6','M25.4','M90.0',

'M89.3','M25.1','M25.0','M24.6','M24.5','M24.4','M24.0','M23.4','M48.5','M86.9','M86.8','M86.6','M86.5','M86.4','M86.3','M86.2','M86.1','M86.0','M85.6','M85.5','M85.4',

'M22.2','M22.1','M22.0','M21.6','M21.5','M21.4','M21.3','M21.2','M21.1','M21.0')

and reapeated should be get count

Re: count repeated value

sunny_talwar — Fri, 17 Jun 2016 12:06:06 GMT

What is WildMatch here?

Re: count repeated value

sagarrahul — Fri, 17 Jun 2016 12:08:06 GMT

data which i given ie 'M22.2','M22.1' etc

Re: count repeated value

sagarrahul — Fri, 17 Jun 2016 12:13:40 GMT

this code i have used

=count(aggr(DISTINCT Count({<ICD_CODE_LEVEL1_org={'D21.6','D21.9','D22.0','D22.1','D22.2,'D35.7','D35.8','D35.9','D36.0','D36.1','D36.7','D36.9','D37.0','D37.1','D37.2','D37.3',

'D37.4','D37.5','D37.6','D37.7','D37.9','D38.0','D38.1','D38.2','D38.3','D38.4','D38.5','D38.6','D39.0','D39.1','D39.2','D39.7',

'D39.9','D40.0','D40.1','D40.7','D17.7','D17.9','D18.0','D18.1','D19.0','D19.1','D19.7','D19.9','D20.0','D20.1','D21.0','D21.1','D21.2','D21.3','D21.4','D21.5','D61.3','D61.8',

'D61.9','D63.0 ','D63.8 ','D64.0','D64.1','D64.2','D64.3','D64.4','D64.8','D64.9','D68.0','D68.1','D68.2','D68.3','D68.4','D68.5','D68.6','D68.8','D68.9','D69.0','D69.1','D40.9',

'D41.0','D41.1','D41.2','D41.3','D41.4','D41.7','D41.9','D42.0','D42.1','D42.9','D43.0','D43.1','D43.2','D43.3','D43.4','D43.7','D43.9','D44.0','D44.1','D44.2','D44.3','D44.4',

'D44.5','D44.6','D44.7','D44.8','D44.9','D46.0','D46.1','D46.2','D46.4','D46.5','D46.6','D46.7','D46.9','D47.0','D47.1','D47.2','D47.3','D29.9','D47.4','D47.5','D47.7','D47.9',

'D48.0','D48.1','D48.2','D48.3','D48.4','D48.5','D48.6','D48.7','D48.9','D50.0','D50.1','D50.8','D50.9','D51.0','D51.1','D51.2','D51.3','D51.8','D51.9','D52.0','D52.1','D52.8',

'D52.9','D53.0','D53.1','D53.2','D53.8','E05.5','E05.8','E05.9','E06.0','E06.1','E06.2','E06.3','D69.2','D69.3','D69.4','D69.5','D69.6','D69.8','D69.9','D72.0','D72.1','D72.8',

'D72.9','D73.0','D73.1','D73.2','D73.3','D73.4','D73.5','D73.8','D73.9','Y84.2','Z51.1'},CLM_TYPE={'Reimbursment'}>}ICD_CODE_LEVEL1_org),HOSPITAL_NAME,HOSPITAL_CODE,CLM_XGEN_CLAIM_NUM,CLM_INTIMATION_DATE))

Re: count repeated value

MK_QSL — Fri, 17 Jun 2016 12:25:46 GMT

I lost here now after comparing your new request and question itself...!!!

Looks like question was irrelevant to your real request.

Re: count repeated value

sagarrahul — Fri, 17 Jun 2016 12:32:19 GMT

see all this values are there

if in this values get repeated when i match with other columns present in my table then i should show me the repeated data

Re: count repeated value

sagarrahul — Mon, 20 Jun 2016 06:17:10 GMT

can anyone help me in this please its urgent for me

just tell me how to count repeated data .

eg :

ICD_CODE_LEVEL1_org

N41.0

R50.9

B54

S82.1

B54

Re: count repeated value

Anonymous — Mon, 20 Jun 2016 06:31:18 GMT

Expression: Count(ICD_CODE_LEVEL1_org)

This is the way, as Sunny mentioned above.

I wonder why you want to repeat those same ICD_CODE_LEVEL1_org in the table.

I think you should only get the no of times the dimension been repeated, That's what your question says

Thanks