Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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