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
Read about Qlik’s Response to COVID-19   Read the LetterJoin the Group.
Highlighted
New 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

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

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

May be this?

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

 

View solution in original post

Highlighted
New Contributor III

where the [UserID] field matches the OSUser()

Thank you!