Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wynnjimbbt
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)
  • Other

1 Solution

Accepted Solutions
sunny_talwar

May be this?

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

 

View solution in original post

2 Replies
sunny_talwar

May be this?

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

 

wynnjimbbt
Contributor III
Contributor III
Author

Thank you!