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

Expression with boolean variable in set analysis

Good Morning,

I've a simple expression like this: Sum(if($(bCondition),Adults))

$(bCondition) is a boolean variable.


How can I "translate" it correctly in set analysis syntax ?

Thanks in advance.

Paolo.

13 Replies
Not applicable

Good Morning PAOLO,

Try this please

Sum( {$<[bCondition] = {'1'} >}  Adults)




agigliotti
Partner - Champion
Partner - Champion

it can't works because bCondition is a variable not a field name.

paolo_mapelli
Creator II
Creator II
Author

Hmm, that's a good compromise, I think I'll follow this way

rahulpawarb
Specialist III
Specialist III

Cheers,

Rahul Pawar