Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
maurorenazco
Contributor
Contributor

Set analysis using a function

Hello I run into the following expression 

sum({<${year=2019}, transfer_agency={=“len(trim(transfer_agency))=0”}>Obligation

my question is related to  section 

transfer_agency={=“len(trim(transfer_agency))=0”}

I cannot tell what the expression is evaluating or assigning . At first I thought it Was $ expansion to evaluate a comparison value, but it is not the right syntax  transfer_agency={=$(“len(trim(transfer_agency)))=0”}.

this part of the expression len(trim(transfer_agency)),  get rid of the leading spaces , and return the length of the string.

but when I read the expression like this 

transfer_agency={=“len(trim(transfer_agency))=0”}

first, I think that  it should be single quotes and not double quotes to evaluate the expression. The to me it seems the expression does the following :

let say agency_transfer =  ‘   N A SA’

transfer_agency=[ (4)=0] 

 

could any one please help me understand the expression, please ?

 

1 Reply
NitinK7
Specialist
Specialist

Hi,

try the below expression it will work

sum({<Year={'2019'},transfer_agency={'$(Len(trim(transfer_agency))=0)'}>}Obligation).