topic Hi Master Dimensions in App Development

Hi Master Dimensions

ali_hijazi — Mon, 03 Jul 2023 07:42:25 GMT

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

Re: Hi Master Dimensions

udit_k — Mon, 03 Jul 2023 12:34:38 GMT

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)

Re: Hi Master Dimensions

ali_hijazi — Mon, 03 Jul 2023 18:21:29 GMT

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

Re: Hi Master Dimensions

udit_k — Tue, 04 Jul 2023 08:49:13 GMT

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);