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

Expression Editor

 

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)

 

1 Solution

Accepted Solutions
sunny_talwar

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)

View solution in original post

2 Replies
sunny_talwar

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)

mcallirgos17
Contributor
Contributor
Author

Thanks that did it!!  Sorry it took so long to reply I didn't know I received a response!

Regards