topic Re: field count in QlikView

field count

Mon, 06 Aug 2012 10:45:04 GMT

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

Re: field count

Mon, 06 Aug 2012 10:58:11 GMT

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

Re: field count

swuehl — Mon, 06 Aug 2012 10:58:16 GMT

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

Re: field count

Mon, 06 Aug 2012 11:05:17 GMT

Hi Pari i want to count at tables or charts

Re: field count

Mon, 06 Aug 2012 11:19:32 GMT

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

Re: field count

Mon, 06 Aug 2012 11:21:44 GMT

post a sample qvw file

Re: field count

Mon, 06 Aug 2012 11:29:40 GMT

i added it thnaks a lot

Re: field count

Mon, 06 Aug 2012 11:35:24 GMT

on which chart / sheet you want to do it?

Re: field count

Mon, 06 Aug 2012 11:37:59 GMT

at copy of isletme sheet

for all graphs i will use it

Re: field count

Mon, 06 Aug 2012 11:44:03 GMT

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

Re: field count

Mon, 06 Aug 2012 11:58:27 GMT

it is not clear to me what you said but

try to make a barchart

dimension DS_DELAY_SUB_CODE

and expression =Count(DS_DELAY_SUB_CODE_1)+Count(DS_DELAY_SUB_CODE_2)+Count(DS_DELAY_SUB_CODE_3)+Count(DS_DELAY_SUB_CODE_4)

Re: field count

Mon, 06 Aug 2012 12:12:59 GMT

thank you very much but for dimesion i tried to merge the columns to cerate DS_deLay_sub_code

but i used concatanate and join but i couldnt, how i will prepare it

Re: field count

Mon, 06 Aug 2012 12:16:04 GMT

which column you want to merge?

Re: field count

Mon, 06 Aug 2012 12:17:50 GMT

F, G, H, İ columns

i tried in the script but it dublicated the data

Re: field count

Mon, 06 Aug 2012 12:26:06 GMT

i dont know how to create DS_DElay_sub_code

because at the and people wants to selecte some codes from DS_DELAY_SUB_CODE

and it will be dynamic