topic Re: acess pb in QlikView

acess pb

master_student — Fri, 31 Mar 2017 08:32:59 GMT

Hello Guys,

I would like to add a condition on my table, if the user logged is Qlv.xxr then only show OpEx_Category= 'TRAINING'

if(OSUser()='ORxxxE\Qlv.xxr',OpEx_Category ='TRAINING', OpEx_Category) but the result :opex category 0 or -1

Thanks for your help

Re: acess pb

Anil_Babu_Samineni — Fri, 31 Mar 2017 09:54:19 GMT

May be use with Match condition. Check the user name it should't be wrong strong

if(Match(OSUser()='ORxxxE\Qlv.xxr'),OpEx_Category ='TRAINING', OpEx_Category)

Re: acess pb

master_student — Fri, 31 Mar 2017 10:10:14 GMT

same thing, the opex category appears with 1 or 0 values. THE user name is correct

Re: acess pb

tamilarasu — Fri, 31 Mar 2017 10:13:55 GMT

Hi Wiem,

Could you elaborate your question little bit? If possible post your qvw file here.

Re: acess pb

Anil_Babu_Samineni — Fri, 31 Mar 2017 10:14:47 GMT

Hope so, you may need section access. And can you let me know where you are trying this?

Re: acess pb

master_student — Fri, 31 Mar 2017 10:16:04 GMT

in the table expression

Re: acess pb

master_student — Fri, 31 Mar 2017 10:17:43 GMT

i have a table that contains many categories and i would like to add a condition if user1 is logged. he could only see category xx using the OSUser() function not section access

Thank you

Re: acess pb

tamilarasu — Fri, 31 Mar 2017 10:22:25 GMT

Try this

If(OSUser()='ORxxxE\Qlv.xxr', If(OpEx_Category ='TRAINING',OpEx_Category), OpEx_Category)

Re: acess pb

master_student — Fri, 31 Mar 2017 10:43:59 GMT

Thanks Tamil, but it still display all opex category for the user ORxxxE\Qlv.xxr

Re: acess pb

tamilarasu — Fri, 31 Mar 2017 11:28:46 GMT

Hi Wiem,

You should see "-" for that specific User Id.

Is the user ID correct? Try using Osuer() function and see whether it is correct or not.

Re: acess pb

master_student — Fri, 31 Mar 2017 13:20:56 GMT

i am sure the user id is correct. i tested it in an object text and put the result in the condition

If(OSUser()='ORxxxE\Qlv.xxr', If(OpEx_Category ='TRAINING',OpEx_Category), OpEx_Category)

i get all categories. could you share your qvw?

Thanks for youe help

Re: acess pb

tamilarasu — Fri, 31 Mar 2017 14:23:29 GMT

Hi Wiem

Please find the attached file. Change the Osuser to your domain id and see whether it's working or not.