Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

ignore selcetions qlik sense


Hi

I have the following N PERIOD MEASURE

rangeavg(above(Count( distinct{$<  Department -= {'Catering'}>}[OrderID] ),0,53))

I want to select a year from a filter pane, but I want this measure to ignore it

I have done the following below and it does not work

rangeavg(above(Count( distinct{$<  Department -= {'Catering'}, Year =>}[OrderID] ),0,53))

I have heard of using concat, but how do I get that to work (if correct method to use) with this above measure

please help

10 Replies
joeybird
Creator III
Creator III
Author

Hi

is there a way in qlik sense  please, that say a year is selected , that the measure can disappear or hide (Line on chart), as I don't want it to show the wrong values when a year is selected?

Kind Regards