Can a measure be used as filter in a table?

[Anonymous]

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?

[zebhashmi]

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 

[Digvijay_Singh]

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

[OmarBenSalem]

Create your measure as a DIMENSION:

and do as follow:

aggr(sum(YourMeasure),YourDimension)

in this case

aggr(sum(YourMeasure),BusinessCritical...)

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:

[krishna_2644 · Accepted solution]

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.

[JRules]

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

[cgrocott]

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.

[remirenaud]

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 !!!