topic Read field data from section access in QlikView

Read field data from section access

Anonymous — Fri, 07 Feb 2014 21:37:36 GMT

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.

Re: Read field data from section access

agilos_mla — Fri, 07 Feb 2014 22:02:53 GMT

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

Re: Read field data from section access

Anonymous — Fri, 07 Feb 2014 22:53:47 GMT

Thanks a lot Michaël!

Re: Read field data from section access

Fri, 21 Feb 2014 17:34:36 GMT

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

Re: Read field data from section access

Anonymous — Fri, 21 Feb 2014 19:10:23 GMT

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'

Re: Read field data from section access

Mon, 24 Feb 2014 07:47:18 GMT

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

Re: Read field data from section access

Anonymous — Mon, 24 Feb 2014 14:44:13 GMT

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

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

Re: Read field data from section access

Mon, 24 Feb 2014 15:46:59 GMT

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

Re: Read field data from section access

Tue, 21 Apr 2015 18:49:43 GMT

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.