Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

3ernardo
New Contributor III

Filtering a dimension based on a condition.

I want to to create a Master Item to be used as a Dimension in some of my charts. I need to show only the streets with more than 9 houses.

I tried the following:

=if([STREET]=(Sum(NUM_OF_HOUSES)>=10),[STREET],Null())

But it returns an Invalid Dimension, any ideas?

Thanks in advance.

Tags (2)
1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: Filtering a dimension based on a condition.

if(  aggr(sum( NUM_OF_HOUSES),STREET)>=10, STREET, Null())

1 Reply
OmarBenSalem
Esteemed Contributor

Re: Filtering a dimension based on a condition.

if(  aggr(sum( NUM_OF_HOUSES),STREET)>=10, STREET, Null())

Community Browser