topic Re: field count in QlikView

field count

Fri, 27 Jul 2012 07:03:28 GMT

Hi all,

At the attached excel, i want to count my "codes" in Column A,B,C,D

for ex: if i dont select any code it must return. 317

if i selecet '34A' it must return 7

if i selecet '89Z' it must return 35+60+14+3= 112

thanks a lot

giakoum — Fri, 27 Jul 2012 07:13:15 GMT

one easy solution would be to add them all to a single column and then count them. Would that be helpful for you?

Fri, 27 Jul 2012 07:19:03 GMT

you can think it as a single column but what is the formula to count

Vincent helped me to use

Sum( SubStringCount

( DS_DELAY_SUB_CODE_1&'|'&DS_DELAY_SUB_CODE_2&'|'&DS_DELAY_SUB_CODE_3&'|'&DS_DELAY_SUB_CODE_4,

Kod ))

this formula.But this time when i select '1A' it counts '1A' and '11A'
and '21A' buy all of these three are different

giakoum — Fri, 27 Jul 2012 07:25:29 GMT

see attached