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: 
john_henry
Contributor III
Contributor III

How do I limit the values in a dimension based on another dimension?

I have the following 2 dimensions:

Column     Values

Type          A,B,C

Name        John, Bob, Jane, Carl, etc..

Type    Name

A          John

A          Bob

B          Jane

C          Carl

I would like to create a table where the first column is "Name", however, I want to limit the values in "Name" to only those where "Type" = A...how do I do that?

I tried to create a derived column using a set analysis, but it requires a sum function or other operational function...here is the syntax I was using, but was not working:  =({<[Type]={'A'}>}[Name])

2 Replies
sunny_talwar

May be try this

If(Type = 'A', Name)

john_henry
Contributor III
Contributor III
Author

wow..that was quick and easy...thanks!