Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rtam1234
Contributor
Contributor

sum of comma separated values in one cell Qlikview

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

1 Solution

Accepted Solutions
MarcoWedel

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

View solution in original post

2 Replies
MarcoWedel

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
Contributor
Contributor
Author

thank you Marco it works!