Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
EduardoCarvalho
Contributor
Contributor

How to sum every number in a cell after "8c~". The number of "8c~" may vary.

Example: 

 

8c~9993|8d~14655|87~0|94~81724f104c72724f10d02c5810|85~140953|86~141003|8e~1801101410102d0200|a9~810107860158|aa~8004b14ff04d|||88~0080|84~01|83~07d1|82~7669766f72756c657a617070637266|81~02&8c~1262|8d~2311|87~0|94~81724f104c72724f10d02c5810|85~140953|86~141010|8e~1801101410102d0200||aa~8004b14ff04d|||88~0080|84~01|83~07d1|82~7669766f72756c657a617070637266|81~64&8c~1785|8d~6529|87~0|94~81724f104c72724f10d02c5810|85~141010|86~141018|8e~1801101410352d0200|a9~810109860160|aa~8004b14ff04d|||88~0080|84~02|83~07d1|82~7669766f72756c657a617070637266|81~02&8c~0|8d~0|87~0|94~81724f104c72724f10d02c5810|||8e~1801101410352d0200||aa~8004b14ff04d|||88~0080|84~02|83~07d1|82~7669766f72756c657a617070637266|81~64

Labels (1)
9 Replies
sunny_talwar

This is in a chart or is this something you want to resolve in the script?

EduardoCarvalho
Contributor
Contributor
Author

isso é uma célula dentro de uma tabela. Gostaria de resolver num script.

sunny_talwar

I am not sure I follow, is this one row of data? do you want to extract it into multiple rows? Can you share more information?

EduardoCarvalho
Contributor
Contributor
Author

Yes, this is one row of data. I tryed to separete the numbers after the "8c~", and then sum , but when the number of "8c~" is high the script became so big. I 'm looking for a simple script that set the "8c~" as a parameter and then sum all of the numbers after it.
sunny_talwar

But you are only looking for 8c~? Because I see there are 84~ and others like those? -> 87~0, 94~81724f104c72724f10d02c5810.. those can all be dropped?

EduardoCarvalho
Contributor
Contributor
Author

In the first moment yes, but after i will apply the same solution to the other delimiters like 8d~
Sue_Macaluso
Community Manager
Community Manager

Is this for Qlik Sense or QlikView. I would love to move this conversation to the appropriate product forum
Sue Macaluso
EduardoCarvalho
Contributor
Contributor
Author

Qlik Sense. I'm sorry if i posted the wrong forum. This is my first post.

Sue_Macaluso
Community Manager
Community Manager

No worries at all. I am going to move this to the Qlik Sense forum.
Sue Macaluso