Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Meet Qlik's New CEO. The Future Is Bright — Here's What to Expect
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
MVP
MVP

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
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