Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

logic

In the dimension i have to consider a Filed called IDNumber...

Iam writing the below expression

If(Status'Active'IDNumber)

Where ever the status is Active i want to display only those IDNUmber's

Is the above expression in the Dimension is correct

1 Solution

Accepted Solutions
sunny_talwar

You can also do this

If(Status = 'Active', IDNumber)

and then make sure to check 'Suppress When Value Is Null' on the dimension tab of the chart properties

View solution in original post

3 Replies
Anil_Babu_Samineni

May be these?

If(Match(Status,'Active'),IDNumber)

OR

If(Status Like 'Active', IDNumber)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

You can also do this

If(Status = 'Active', IDNumber)

and then make sure to check 'Suppress When Value Is Null' on the dimension tab of the chart properties

sudeepkm
Specialist III
Specialist III

I think you may also try using the condition in your expression instead of Dimension as another approach.

=sum({< Status={'Active'}   >}OrderID)