Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

expression based on filter and osuser


Hi

I only wish to sum on person logged in

I have a text box that shows show's who's logged in via a windows login using

domain = OpenWorld

Username =jo111111

on text box expression is

osuser()

this gives me UserDirectory=OpenWorld;UserId=jo111111

I have a filterpane called UserId that contains jo111111

there is a chart showing sales, my expression is like this, but it does not work I only wish to sum on person logged in

sum ({$<OSUser= {UserID}>}SALES)

how can I get this to work please

11 Replies
sunny_talwar

Issue with "table chart on a sheet"? Not sure what we are talking about here?

joeybird
Creator III
Creator III
Author

hi

I have used below

count({$<UserID = {'$(=SubField(OSUser(), '=', -1))'}>}CustID)

on table on a sheet...this gives me 0 or 1, how can I then limit the count to 1 on the table please?