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:13 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.

PrashantSangle — Thu, 27 Jun 2019 04:32:38 GMT

in this case repeat same line twice

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

Regards,

Prashant Sangle

pathompong_vm — Thu, 27 Jun 2019 08:35:03 GMT

It's working very fine, Thank you so much