This content has been marked as final. Show 2 replies
New to Qlik Sense. I love it!
In expression editor I need below. I've tried multiple variations with no luck. I have been successful in using this before but NOT with the (a)+(b) portion. I've tried set analysis and did not work.
I don't have access to create a new field or data load unfortunately the express editor is all I have to create what I need.
=If(home=’c’ and (a)+(b)<100,dual(‘100’,1)
,If(home=’c’ and (a)+(b)>=100 and (a)+(b)<200,dual(‘200’,1)