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: 
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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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)