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: 
khaycock
Creator
Creator

Select all fields but one

Hey,

I'm trying to create a button that selects all of a field except one.

I've tried to do select in field and select excluded but I can't figure it out, I'm thinking because the field has spaces in it maybe?

I want to include all fields that are part of [Profit Center Desc], except "Used (Memo - not in total)".

Help?

1 Solution

Accepted Solutions
sunny_talwar

May be with two actions

1) Select in Field

[Profit Center Desc]

Search String

Used (Memo - not in total)

2) Select Excluded

View solution in original post

6 Replies
sunny_talwar

May be with two actions

1) Select in Field

[Profit Center Desc]

Search String

Used (Memo - not in total)

2) Select Excluded

khaycock
Creator
Creator
Author

This only selects "Used (Memo - not in total)" rather than excluding it

sunny_talwar

Did you add the second action of Select Excluded?

khaycock
Creator
Creator
Author

Yeah what should i put in the field box? I tried it empty and with Used (Memo - not in total) in it but still just selected "Used (Memo - not in total)" instead

sunny_talwar

You need to put the field name

[Profit Center Desc]

khaycock
Creator
Creator
Author

Ahhh amazing thank you!!