Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
master_student
Contributor III

acess pb

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

Capture.PNG

Thanks for your help

11 Replies
Highlighted

Re: acess pb

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
master_student
Contributor III

Re: acess pb

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

Highlighted

Re: acess pb

Hi Wiem,

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

Highlighted

Re: acess pb

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
master_student
Contributor III

Re: acess pb

in the table expression

Highlighted
master_student
Contributor III

Re: acess pb

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

Highlighted

Re: acess pb

Try this

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

Highlighted
master_student
Contributor III

Re: acess pb

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

Capture.PNG

Highlighted

Re: acess pb

Hi Wiem,

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

Capture.PNG

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