Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
shivamkedia
Partner
Partner

like in Set Analysis

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))

 

 

 

1 Reply
dilipranjith
Partner
Partner

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