Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
EduardoCarvalho
New 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 (2)
9 Replies

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

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

EduardoCarvalho
New Contributor

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

Community Manager
Community Manager

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

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