sum of comma separated values in one cell Qlikview

[rtam1234]

Hello experts,

Is there a way to sum the quantities in one cell comma separated values? Please see data below.

Result should be 3. When using subfield, it is showing as 6 due to the data source has 2 of the same rows(duplicate)

Thanks,

Ran

[MarcoWedel · Accepted solution]

Hi,

I guess your best approach would be to eliminate your redundancy as it might cause issues beyond summing those quantities.

However, one solution to sum your comma separated [SKU QTY] values would be:

Evaluate(Replace([SKU QTY],',','+')) as [SKU QTY]

hope this helps

regards

Marco

[rtam1234]

thank you Marco it works!