topic Re: Select all fields but one in QlikView

Select all fields but one

khaycock — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Select all fields but one

sunny_talwar — Mon, 13 Feb 2017 10:18:51 GMT

May be with two actions

1) Select in Field

[Profit Center Desc]

Search String

Used (Memo - not in total)

2) Select Excluded

Re: Select all fields but one

khaycock — Mon, 13 Feb 2017 10:20:39 GMT

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

Re: Select all fields but one

sunny_talwar — Mon, 13 Feb 2017 10:21:23 GMT

Did you add the second action of Select Excluded?

Re: Select all fields but one

khaycock — Mon, 13 Feb 2017 10:22:39 GMT

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

Re: Select all fields but one

sunny_talwar — Mon, 13 Feb 2017 10:23:11 GMT

You need to put the field name

[Profit Center Desc]

Re: Select all fields but one

khaycock — Mon, 13 Feb 2017 10:24:13 GMT

Ahhh amazing thank you!!