Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
jmaurysuarez
Contributor
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:

table1.PNG

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

table2.PNG

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?

1 Solution

Accepted Solutions
krishna_2644
Specialist III
Specialist III

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.

View solution in original post

7 Replies
zebhashmi
Specialist
Specialist

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

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:

Capture.PNG

Capture.PNG

krishna_2644
Specialist III
Specialist III

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

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

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

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