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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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 (2)
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)))'