topic Re: comma separated string field value count in QlikView

comma separated string field value count

satheshreddy — Fri, 16 Feb 2018 08:09:14 GMT

Hi All,

Can anyone help me on the below:

I have mapping table data and comma separated field based on which I have to count the volume.

my expected count should as below:

1) count of branch only

2) count of branch and machine assisted only.

likewise for each value in value field(Mapping table).

Thanks in advance.

satheshreddy — Fri, 16 Feb 2018 08:12:03 GMT

plz find attachment

vishsaggi — Fri, 16 Feb 2018 08:19:52 GMT

‌nnot sure exactly your output may be try this

= count({<Value = {‘Branch’} >} channel_desc)

= count({<Value = {‘Branch’, ‘Machine Assisted’} >} channel_desc)

satheshreddy — Fri, 16 Feb 2018 08:20:52 GMT

ATM

ATM,BMB

ATM,BMB,BRANCH

ATM,BMB,BRANCH,CO_UK

ATM,BMB,BRANCH,CO_UK,MACHINE

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT,POST

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT,POST,ROLB

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT,POST,ROLB,TEL

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT,POST,ROLB,TEL,WCHAT

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT,POST,ROLB,WCHAT

ATM,BMB,BRANCH,CO_UK,MACHINE,PINGIT,POST,TEL

vishsaggi — Fri, 16 Feb 2018 08:24:19 GMT

‌ddoesn’t help. What is the output result you are expecting?can you elaborate?