Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
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?