Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
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.
Any suggestions?
=If(home=’c’ and (a)+(b)<100,dual(‘100’,1)
,If(home=’c’ and (a)+(b)>=100 and (a)+(b)<200,dual(‘200’,1)
May be try this
If(home = ’c’ and ((a)+(b)) < 100, Dual(‘100’,1),
If(home = ’c’ and ((a)+(b)) >= 100 and ((a)+(b)) < 200, Dual(‘200’,1)
May be try this
If(home = ’c’ and ((a)+(b)) < 100, Dual(‘100’,1),
If(home = ’c’ and ((a)+(b)) >= 100 and ((a)+(b)) < 200, Dual(‘200’,1)
Thanks that did it!! Sorry it took so long to reply I didn't know I received a response!
Regards