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

Field selection with set expression in toggle button

I'm using the button for navigation extension and I want to toggle one field value. The idea is to select all the values below one limit. The limit is simply

avg(field1)+2*stdev(field1)

I found out that 

= '<= $(=92870)'

 works perfectly, but when I try to replace number with the limit like this

='<= $(=$(=avg(field1)+2*stdev(field1)))'

the button stops working, even when the expression editor says everything is OK and even shows the correct limit exactly as when I wrote the number manually

ok.png 

Any idea why this doesn't work? 

Labels (4)
1 Solution

Accepted Solutions
anseglko
Creator
Creator
Author

Solved it myself. The number had to be rounded to a full integer for the button to work.. 

='<= $(=round(avg(field1)+2*stdev(field1)))'

 

View solution in original post

1 Reply
anseglko
Creator
Creator
Author

Solved it myself. The number had to be rounded to a full integer for the button to work.. 

='<= $(=round(avg(field1)+2*stdev(field1)))'