Equivalent of like on Qlikview

[#1]

hello

i have a table with this info example...

12300     1

12301     2

12302     3

12304     4

13300     1

13301     2

13302     3

13303     4

i need and expresion for a chart box where sum the rows that start with '12' for example and it has to show 10 as a result.

thanks

[#2]

COL_A     COL_B

12300     1

12301     2

12302     3

12304     4

13300     1

13301     2

13302     3

13303     4

try this:

SUM( IF( TEXT( COL_A) LIKE '12*', COL_B ) )

[#3]

Eduardo

It didn't work...

[Gysbert_Wassenaar · Accepted solution]

Try something like sum({<Field1={"12*"}>} Field2)

[#5]

Verify the file

[#6]

Thanks