Hi Master Dimensions

[ali_hijazi]

Hello Qlik_sters
I have a QVF file with section access as well as some users have a list of columns under the OMIT field
now if I have a chart with a field1 for example and this field is under the OMIT for some users then these users will get the "incomplete visulization" error
is there a way to hide this dimension from the chart so that to avoid the above error message?
kindly advise

[udit_k]

use below expression in show column if condition to hide & show respective OMIT Field:-

expression value i.e. OSUER will be different  for different OMIT Field as per defined in Section access script.

=if(wildmatch(OSUser(),'ABC','PQR','XYZ'),1,0)

[ali_hijazi]

But the list of users is long

There is a group of 25 users who have  omit values

So definitely I won't check for names to hide it show dimension

[udit_k]

create a replica of the section access table. 

set osuser() into a variable and use that value to get the related group

set vUser =OSUser() ; 

use below expression in show column if condition to hide & show respective OMIT Field using Group instead of individual user:-

If(wildmatch(only({<USER={"$(vUser)"}>} GROUP),'ABC,'XYZ'),1,0);