Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Log in user data display in straight table ,others data should not show

hi Guru's,

I have Bar Chart.

Dimension:Days Range

Expression:Count(worker)

If i click on 7-12 Months Bar ->second graph will Display->if u select "Rsuu L Qnikkt" bar ->third straight table Will Display

Note:login id:3,password 3,

Clear selections after login

issue:3 rd straight table should not allow to display other than "Rsuu L Qnikkt"

because he is the login user

How to chieve this.

if i use section access bar charts would not show full data

Requirement is bar charts should show full data and table shows only login user data

Please find the attached sample application

5 Replies
Not applicable
Author

User OSUser() function on the Straight table calculated dimension.

IF( USERNAME = OSUser() , DIM1 ,null()  )

Anonymous
Not applicable
Author

Hi Thanks for your Time.

OSUser() field not there in 3rd Straight Table

ecolomer
Master II
Master II

I can see all tables

p34.png

p35.png

p36.png

p37.pngp38.png

Not applicable
Author

OSUser() is not a field. Its a in built qlikview function to show NTName of the machine you log on.

Anonymous
Not applicable
Author

Yes but actual dashboard doesn't contain List box .

Follow these steps:

If i click on 7-12 Months Bar ->second graph will Display->if u select "Rsuu L Qnikkt" bar ->third straight table Will Display


In third straight table can show only login user details,if u click on other than login user it should throw error or no data display.

ISSUE: 3rd Straight table should not show other than login user details