count diff value in single column

[sagarrahul]

hiiii

need a help

Black List Code

H26.9

H26.9

H26.9

H26.9

H26.9

H25.9

H11.0

H26.9

H26.9

H26.9

in this column i have total 10 values

but in this there are different values

H26.9

H25.9

H11.0

now what i want is to count this individuals in different column and divide by 10

eg :

H26.9 =8

H25.9=1

H11.0=1

so anyone can help me in this

[tamilarasu]

Hi,

Straight Table -> Add [Black List Code] as Dimension -> Expression as Count([Black List Code])

[sagarrahul]

thanks you for your help

But on thing more Tamil nagaraj this Black List Code are coming from a expression where they are in a wild match

so now how to i bring it as i want in my above query

[tamilarasu]

Sagar,

Could you please share some sample application. It would be helpful for me to provide the solution.

[sagarrahul]

means what u want

[sagarrahul]

see this table i am having need help me in this    

HOSPITAL_NAME

HOSPITAL_CODE

CLM_XGEN_CLAIM_NUM

CLM_INTIMATION_DATE

CLM_LEVEL_OF_CARE

Claim_Type

total count of claims

Black List Code

ICD Code Blacklist

Value

status

max_date

Claim _no

Current_date

Differnce

Claim_num

'Dr.Agarwal's Eye hospital'

HEGIC-HS-03644

RC-HS15-10334760

28-Jan-2016

Secondary

-

1

H26.9

1

1.0

Outlier

28-Jan-2016

RC-HS15-10334760

15-Jun-2016

140

-

'Dr.Agarwal's Eye hospital'

HEGIC-HS-03644

RC-HS15-10335711

03-Feb-2016

Secondary

-

1

H26.9

1

1.0

Outlier

03-Feb-2016

RC-HS15-10335711

15-Jun-2016

134

-

'Dr.Agarwal's Eye hospital'

HEGIC-HS-03660

RC-HS15-10341139

08-Mar-2016

Secondary

-

1

H26.9

1

1.0

Outlier

08-Mar-2016

RC-HS15-10341139

15-Jun-2016

100

-

'Dr.Agarwal's Eye hospital'

HEGIC-HS-03663

RC-HS15-10343361

22-Mar-2016

Secondary

-

1

H26.9

1

1.0

Outlier

22-Mar-2016

RC-HS15-10343361

15-Jun-2016

86

-

'Dr.Agarwal's Eye hospital'

HEGIC-HS-03663

RC-HS16-10352751

20-May-2016

Secondary

-

1

H26.9

1

1.0

Outlier

20-May-2016

RC-HS16-10352751

15-Jun-2016

27

-

'Dr.Agarwal's Eye hospital'

HEGIC-HS-03679

RC-HS15-10336520

08-Feb-2016

Secondary

-

1

H26.9

1

1.0

Outlier

08-Feb-2016

RC-HS15-10336520

15-Jun-2016

129

-

'Dr.Agarwal's Eye hospital'

HEGIC-HS-03679

RC-HS15-10337526

15-Feb-2016

Secondary

-

1

H26.9

1

1.0

Outlier

15-Feb-2016

RC-HS15-10337526

15-Jun-2016

122

-

'Dr.Agarwal's Eye hospital'

HEGIC-HS-03680

RC-HS16-10352247

17-May-2016

Secondary

-

1

H26.9

1

1.0

Outlier

17-May-2016

RC-HS16-10352247

15-Jun-2016

30

-

[susovan]

Hi sagar,

Try this way,

Select your expression from "Expression" tab than do this change.

[tamilarasu]

I meant your expression.

[jonathandienst]

I am afraid that does not help. You say the blacklist code is an expression. How do you expect use to help if we do not know what that expression looks like? Did you try adapting tamilarasu's suggestion by using a calculated dimension and a suitably modified expression?

I suggest that you upload a sample qvw with some representative data.

Preparing examples for Upload - Reduction and Data Scrambling

[ramasaisaksoft]

Hi Sagar,

Above yellow color (Show Frequency)will help ypu to specify no.of times the value repeated in a list box

so ,try to create the list box with your expression and select this option.

i hope it will help you.