Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

comma separated string field value count

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.

4 Replies
Creator III
Creator III

plz find attachment

  

CHANNEL_DESCValue
COUNTER   Branch
IPAD      Branch
SR_BRANCHBranch
BRANCH    Branch
AO_BRANCH Branch
LS_BRANCHBranch
RS_BRANCHBranch
CMP_BRANCHBranch
EXASD     Machine Assisted
KIOSK     Machine Assisted
QSPMachine Assisted
MCCAMachine Assisted
ASDMachine Assisted
ATM       Machine Assisted
ATMQR     Machine Assisted
CCDMMachine Assisted
IVR       Machine Assisted
CMP_POST  Mail
MN_POST   Mail
AO_BMB    Mobile
PDC_BMBMobile
BMBMobile
AO_BMBI   Mobile
AO_PINGIT Mobile
PINGITMobile
AO_PINGITIMobile
CMP_WCHAT Online
AO_CO_UK  Online
CMP_CO_UK Online
AO_ROLB   Online
ROLB      Online
INTERNETOnline
MN_ROLB   Online
PDC_ROLBOnline
CMP_ROLB  Online
CO_UK     Online
PDC_CO_UKOnline
EXCO_UK   Online
RS_OTHEROthers
MULTI CHANOthers
CMP_OTHER Others
BUSINESSOthers
AO_OTHER  Others
SR_OTHEROthers
AO_TEL    Telephone
SR_TELTelephone
RS_TELTelephone
SkybranchTelephone
LS_TELTelephone
CMP_TEL   Telephone
TEL       Telephone
Champion III
Champion III

‌nnot sure exactly your output may be try this

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

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

Creator III
Creator III

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
Champion III
Champion III

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