10 Replies Latest reply: Sep 27, 2017 7:18 AM by Joanna Seldon RSS

    ignore selcetions qlik sense

    Joanna Seldon


      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