comma separated string field value count - Qlik Community

satheshreddy · ‎2018-02-16

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 · ‎2018-02-16

plz find attachment

vishsaggi · ‎2018-02-16

‌nnot sure exactly your output may be try this

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

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

satheshreddy · ‎2018-02-16

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 · ‎2018-02-16

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