Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist III
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.

View solution in original post

7 Replies
Highlighted
Specialist
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
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
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

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

Highlighted
Specialist III
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.

View solution in original post

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