Read field data from section access

[Anonymous]

Hi,

     I am wondering if there's a way to read the actual section access values, here's the scenario.

I've got a huge file, lets say 115 columns, 30 of those columns are payments related. Some people will be allowed to see them but other wont, it would be crazy using OMIT (if that's what I should really use), so I was thinking about adding one boolean column in section access called something like "PaymentsAllowed". Then in qlikview I can conditionally show those columns using that boolean column.

[agilos_mla · Accepted solution]

No Need to read Section ACCESS.

Indeed, do create a boolean column "PAYMENTSALLOWED" (upper case in the section access)

This column don't required to be linked to the datamodel.

Add in Section Application,

LOAD NTAME ,

          PPAYMENTSALLOWED

Resident [YourSectionAccessTable];

Since Section access is applied at opening you get for each user one island table with a single boolean value you can use in the condition Show

Michael

[Anonymous]

Thanks a lot Michaël!

[#4]

Hi Michael,

i also require exactly the mentioned case. I now got the table with my NTNAME's listed also in the section access in my application.

The table has about 50 NTNAME's. How do i manage to compare the NTNAME's with OSUSER function and the boolean flag to decide if i hide or show an object for the user?

No idea how to search the NTNAME attribute for the corresponding OSUSER.

Regards

Markus

[Anonymous]

Hi Markus,

     In your load script do it like this:

LOAD if(upper(OSUser())=NTNAME,SEENAMES) as SEENAMES
Resident SA
where not IsNull(if(upper(OSUser())=NTNAME,SEENAMES));

SA is the name I gave to my section access table,

I'm using upper because my access list has the NT all in capitals, seenames has TRUE/FALSE value. Doing this you'll get 1 unique value, then you can use it as it was a variable. For example in conditional show: SEENAMES = 'TRUE'

[#6]

Hi Oscar,

thanks for the reply. But your example only checks OSUSER() on script load runtime isn't it?

So if i use the example the load statement just extracts my NTNAME  but i need to have all users with true flag extracted and then they have to be checked in the show condition online as this is a server application.

Markus

[Anonymous]

Ah sorry, that's right... ok so just use set analysis in condition:

=Maxstring({<NTNAME={$(=OSUSER())}>} SEENAMES) = 'TRUE'

[#8]

Hi Oscar,

thanks for the hint. Set Analysis was not in my mind to filter the table. As i now see the sytnax it is as simple as it is.

Thanks

Markus

[#9]

Hi Michael,

I'm new to the qlikview.I have the below requirement.please let me know how to achieve column level data reduction with filtering of data. using Boolean condition.

source table....second table I need output below format.

please help me.