topic Need help with Section Access (multiple value from one field) in QlikView

Need help with Section Access (multiple value from one field)

pathompong_vm — Sat, 16 Nov 2024 03:10:15 GMT

I need your help about section access,

I have one field that I would like to control all section as follow (field called 'TEST');

TEST

-A1

-A2

-B

-C

I would like to make section access something like this;

USER TEST
MIKE *
SARAH B
JOHN C
BEN A1,A2
TOM A1,C

Now I can do control section access for MIKE, SARAH and JOHN.

But what should I do section access for BEN and TOM???

Thanks.

Re: Need help with Section Access (multiple value from one field)

Vegar — Thu, 27 Jun 2019 04:42:53 GMT

In your example the SA will look for an value equal to "A1,A2" and "A1,C". You need to split them up like I've done below.

MIKE *
SARAH B
JOHN C
BEN A1

BEN, A2
TOM A1

TOM C2

Re: Need help with Section Access (multiple value from one field)

pathompong_vm — Thu, 27 Jun 2019 08:34:41 GMT

It's working very fine, Thank you so much

Re: Need help with Section Access (multiple value from one field)

abhi1693r — Thu, 27 Jun 2019 15:33:54 GMT

Hi, I had a similar complication. So I have made a multi-box with a field 'A' having three levels 1, 2 and 3. Now as multi-box works, I can filter the data by selecting 1,2 or 3 or a combination of these levels. My requirement is that if someone selects 2, 1 should automatically be selected and if someone selects 3, 1 and 2 should be auto selected.

Is this possible?

PS: Also, I have multiple fields from A to Z@Vegar