Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

john_henry
New 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
MVP
MVP

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

May be try this

If(Type = 'A', Name)

john_henry
New Contributor III

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

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

Community Browser