field count

[#1]

Hi All

i coulndt solve my issue.

At the attached excel.  Columns (F, G, H , I) has Sub_delay_code_1, Sub_delay_code_2, Sub_delay_code_3, Sub_delay_code_4

i want to count all codes in this four columns

for example '15A' is 3+1+2+0 = 6 in all four columns

thnaks a lot

[#2]

you want to count it in loading script or on the chart/textbox?

[swuehl]

Maybe like this:

=rangesum(

count({<DS_DELAY_SUB_CODE_1 = {'15A'}>} DS_DELAY_SUB_CODE_1)

,count({<DS_DELAY_SUB_CODE_2 = {'15A'}>} DS_DELAY_SUB_CODE_2)

,count({<DS_DELAY_SUB_CODE_3 = {'15A'}>} DS_DELAY_SUB_CODE_3)

,count({<DS_DELAY_SUB_CODE_4 = {'15A'}>} DS_DELAY_SUB_CODE_4)

)

Or create a concatenated field in your load script that contains all values of the four fields.

Hope this helps,

Stefan

[#4]

Hi Pari i want to count at tables or charts

[#5]

Hi Swuehl

but i have about 100 hundred codes

on the other hand i  wanted to put the four coulmn into one column but  i coulndt , becasuse it dublicated the data

[#6]

post a sample qvw file

[#7]

i added it thnaks a lot

[#8]

on which chart / sheet you want to do it?

[#9]

at copy of isletme sheet

for all graphs  i will use it

[#10]

i want to count all the codes in four columnd to prepare this graphs