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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show in a list box only those values which meet the condition?

Hi,

I want to display the names of people in the list box. But only those for which the sum of salaries for selected months is greater than the variable vSalary.

=If(Aggr(Sum(Monthly_Salary),Name)>=vSalary,Name)

Could you please help me. Thank you in advance.

1 Reply
Anonymous
Not applicable
Author

You may use this script in List box's expression.

Go to List Box object --> Click on field drop down --> Scroll extremely down --> You may see "<Expression>" option --> Click on it and copy/paste your above script.

Thanks