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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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
MVP
MVP

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