# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Did you mean:
Highlighted
Contributor

## Can a measure be used as filter in a table?

Hi,

I'm having a question about if this is possible or not do this kind of filtering, let me explain with an example.

I have this table:

And the columns January and February are set analysis expressions for those specific months:

My question is: Is there a way where I can click for example in cell where there is a value of 40 and a filter will be applied for both "BCS2" and month of January, for further data analysis in other objects?

Tags (4)
1 Solution

Accepted Solutions
Highlighted
Specialist III

## Re: Can a measure be used as filter in a table?

Hi - This functionality is not straight forward in Qlik sense.

but theres a work around for this.(we can attain 95% functionality as per your requirement)

you have to create calculated fields and then use them in the table as dimension.

check the attached.

7 Replies
Highlighted
Specialist

## Re: Can a measure be used as filter in a table?

I think one tricky way is to make the other table with dimension Incidents and measure would be same as you have

so it would be 40 an 40 on both side and you would be able to select 40

Highlighted
Master III

## Re: Can a measure be used as filter in a table?

I think not possible, you can make selections in dimension values only, measure cells don't allow selections. Its like selecting two dimensions in one go, which I think is not possible in native charts

Highlighted
Partner

## Re: Can a measure be used as filter in a table?

Create your measure as a DIMENSION:

and do as follow:

aggr(sum(YourMeasure),YourDimension)

in this case

Per analogy:

I create a table with 2 dimensions:

Dimension

=aggr(Sum(Measure),Dimension)

and now I can filter by this "supposed to be " measure:

Highlighted
Specialist III

## Re: Can a measure be used as filter in a table?

Hi - This functionality is not straight forward in Qlik sense.

but theres a work around for this.(we can attain 95% functionality as per your requirement)

you have to create calculated fields and then use them in the table as dimension.

check the attached.

Highlighted
Contributor

## Re: Can a measure be used as filter in a table?

Hi,

found this subject but I don't understand what you're doing so I cannot use it on my data. I  understand why but not how you need to transform your measure into a dimension.

(I'm new to QlikSense since 3 weeks).

With kind regards,

J

Highlighted
Partner

## Re: Can a measure be used as filter in a table?

Spoiler
This works great, thanks.

It's probably not ideal from a performance perspective, but works fine for replacing this missing functionality in Sense.

Works fine with Set Analysis too.
Highlighted
Contributor

## Re: Can a measure be used as filter in a table?

Hi - your solution worked pretty good for me, except that I would like to be able to filter out the null values in the list and this is a problem as my code below, while populating the list with"Y", does not populate with "N" - can you assist?

= aggr(if (count({\$< [Powertrain type]={'HEV','PHEV','BEV'}>} total < [Make Model],[Region-4] > ([Make Model] )) >0,'Y','N'),[Make Model],[Region-4] )

Thanks !!!