Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
GianluigiBI
Contributor
Contributor

Filtering based on measure

Hi guys, I need your help.
I have a bar chart with multiple measures calculated like this:

sum (
if(transaction_date-original_transaction_date<=5 and fl_return=1,1,
0
))

The point is: I would like to be able to filter the entire dashboard on these measures

Labels (6)
1 Reply
vinieme12
Champion III
Champion III

create a new field during data load and then apply a 9filter on this new field

 

SomeTable:

load  *

,if(transaction_date-original_transaction_date<=5 and fl_return=1,1) as flag_field

From someSource;

 

Then use this field to either apply a filter

 

or

Use in set analysis in your measures

sum({<flag_field={1}>} someMeasure)

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.