Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - Ignore field value until explicitly selected

Hi all

I have a 'Rejection Status' field that contains two values only; 1) Accepted 2) Rejected

I would like to ignore all 'Rejected' values in an expression until it is explicitly selected in the list box.

Scenarios

1) Nothing selected in 'Rejection Status' - Sum([Net Order Value]) for Accepted lines only

2) 'Accepted' selected in 'Rejection Status' - Sum([Net Order Value]) for Accepted lines only (same as 1)

3) 'Rejected' selected in 'Rejection Status' - Sum([Net Order Value]) for Rejected lines only

4) Everything selected in 'Rejection Status' - Sum([Net Order Value]) for all lines

Can set analysis handle this?

Thanks

1 Reply
swuehl
MVP
MVP

Maybe like

=Concat({<Status *= {'$(=If(GetSelectedCount(Status),'*','Accepted'))'}>} Status)