Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
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);