Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
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
satyadev_j
Specialist
Specialist

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