I want a comma separated value in a qliksense text box.

Consider the following data

REGION|MARKET|METRIC|VALUE

ASP|INDIA|S1|1

ASP|CHINA|S1|0

ASP|INDIA|S2|0

ASP|CHINA|S2|1

ASP|HONGK|S1|1

EUR|UK|S1|1

EUR|UK|S2|0

USA|TX|S1|1

USA|TX|S3|1

I want an output in a qliksense text box with the following logic:

Sum of VALUE column where VALUE=1 for metric S1.

Desired output in text box: ASP(2),EUR(1),USA(1)

I would really appreciate your help