like in Set Analysis

[shivamkedia]

suppose I have a table having column col1 and col2.  I have 2 buttons(vButtonVariable) named  allocated and allocable

col1                           col2

allocated_x             1

allocable_z            2

allocated_y            3

allocable_a            4

I want an set analysis in qlik sense  to which gives sum of prefix having allocable and allocated which looks like

col1                     col2

allocated           4(1+3)

allocable           6(2+4)

I have tried        pick( $(Buttonvariable),

sum({<col1={'allocated*'}>}col2),sum({<col1={'allocated*'}>}col2))

[dplr-rn]

replace single quotes with double quotes. Single quotes is used for literals not search
change it to
sum({<col1={"allocated*"}>}col2)