Ignoring selections.

[john_duffy]

Hello.

I have two identical charts that count FieldA by Dim1. I have a list box with all employees. The employee field in the list box is not included in the chart, however, it is linked to FieldA and Dim1.

When a user selects an employee, I would like one of the charts to calculate the expression based on the data drilled down by the employee selection and the second chart to ignore the selection and render the chart as if no employees were selected.

Can this be done using set analysis? We are on QV8.5.

Thanks for your help.

[#2]

To ignore selections in Set Analysis, use: {1}

So in an expression:

Sum({1} Sales)

If you want to respect all selections, except Employee, then use:

Sum({<Employee=>} Sales)

Where Employee is the name of the field the selection is in.

[john_duffy]

Thanks for the help.

My expression ended up being a bit more complicated because the value in the list box was calculated from several fields. I used an expression something like Count({$<Employee = {"*"},Dept = {Val1}>} Sales)

Your response definitely steered me in right direction and I was able to resolve my issue.

Thanks.