Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

where the [UserID] field matches the OSUser()

I need a calculated dimension to suppress Nulls where the [UserID] field matches the OSUser() value

I have a syntax issue below:

This works in a text box:
=if(Sum({$<UserID = {'$(=SubField(OSUser(), '\', -1))'}>} [Total Revenue])>0,1,0)

I need the below to return a 1 or Null(); and to suppress Nulls:
=if({$<UserID = {'$(=SubField(OSUser(), '\', -1))'}>},1,null())

Labels (1)
1 Solution

Accepted Solutions
Highlighted

Re: where the [UserID] field matches the OSUser()

May be this?

=If(UserID = SubField(OSUser(), '\', -1), 1, Null())

 

View solution in original post

2 Replies
Highlighted

Re: where the [UserID] field matches the OSUser()

May be this?

=If(UserID = SubField(OSUser(), '\', -1), 1, Null())

 

View solution in original post

Highlighted
Contributor III
Contributor III

where the [UserID] field matches the OSUser()

Thank you!