topic Re: Create a Flag to reduce Field 'OSUser' to only show a specific set of users in QlikView

Create a Flag to reduce Field 'OSUser' to only show a specific set of users

Anonymous — Thu, 07 Feb 2013 07:05:44 GMT

I have a model that shows which clients are viewing QVW's online.

The clients are loaded into the script using a Load Inline Statement.

I want to create a Flag in the script that reduces those users to a specific client, Shebo.

Here is a sample script:

Groupings:

LOAD * INLINE [

QVS OSUser, UserType

CUSTOM\SheboA, Customer

CUSTOM\SheboB, Customer

CUSTOM\SheboC, Customer

CUSTOM\SheboD, Customer

CUSTOM\SheboE, Customer

CUSTOM\ProlineA, Customer

CUSTOM\ProlineB, Customer

CUSTOM\ProlineC, Customer

CUSTOM\YealinkA, Customer

CUSTOM\YealinkB, Customer

CUSTOM\YealinkC, Customer

];

Re: Create a Flag to reduce Field 'OSUser' to only show a specific set of users

Thu, 07 Feb 2013 07:22:34 GMT

Hi,

have u tried using section access?

Section Access;

Access:

LOAD * INLINE [

ACCESS, USERID, ACCESS_LEVEL

ADMIN, ADMIN, -1

USER, USER1, -1

USER, USER2, -1

USER, USER3, 0

USER, USER4, 0

USER, USER5, -1

];

Section Application;

LOAD ACCESS_LEVEL

Resident Access;

Hope helps,

David Sugito

Re: Create a Flag to reduce Field 'OSUser' to only show a specific set of users

Anonymous — Thu, 07 Feb 2013 07:32:54 GMT

Thanks David

There are many users, so it would be easier to create a flag I think. I don't need to make it accessible to all users, just the one user. I want to know how to create a flag as well.

Re: Create a Flag to reduce Field 'OSUser' to only show a specific set of users

Thu, 07 Feb 2013 07:37:12 GMT

Hi,

FYI, the ACCESS_LEVEL on my script (above) is a flag..

Am I missing something?

Regards,

David Sugito

Re: Create a Flag to reduce Field 'OSUser' to only show a specific set of users

Anonymous — Thu, 07 Feb 2013 09:40:13 GMT

Hi David,

I see where you are coming from with the Section Access, but I don't want to approach the flag from that way I don't think.

Maybe if I changed Specific User to Specific Product it will make more sense what I'm looking for?

Regards,

Chris

Re: Create a Flag to reduce Field 'OSUser' to only show a specific set of users

Jason_Michaelides — Thu, 07 Feb 2013 11:56:25 GMT

Why don't you use the same solution you were given in your other, smiliar, post?

http://community.qlik.com/thread/72094?tstart=0

Jason