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

ignore selcetions qlik sense

Joanna Seldon Sep 26, 2017 6:23 AM

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

Re: ignore selcetions qlik sense

Sunny Talwar Sep 26, 2017 7:35 AM (in response to Joanna Seldon)

This doesn't ignore selection in Year? Is your Year field called Year or something else?
RangeAvg(Above(Count(DISTINCT{$<Department -= {'Catering'}, Year =>} [OrderID]), 0, 53))
Like Show 0 Likes (0)

Actions
- Re: ignore selcetions qlik sense
  
  Joanna Seldon Sep 26, 2017 7:40 AM (in response to Sunny Talwar )
  
  Hi
  
  it does not seem to , as the rolling average number slightly changes when you select a year..
  
  I want a user to select a year of their choice and the rolling average figures are un affected (not changed)..
  
  this process normally works using the Year = for other set analysis measures..but does not seem to work for using the n period calculation using RangeAvg(above (Count
  
  please help
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: ignore selcetions qlik sense
    
    Sunny Talwar Sep 26, 2017 7:42 AM (in response to Joanna Seldon)
    
    I am not sure if you can share a sample or not, but it might help to look at it to figure out what might be wrong here
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: ignore selcetions qlik sense
      
      Joanna Seldon Sep 26, 2017 7:59 AM (in response to Sunny Talwar )
      
      Hi
      
      I cant sorry
      
      but I have the dimension Weekend(OrderDate)
      
      Measure 1 count(OrderID)
      
      measure 2 rangeavg(above(Count( distinct{$< Department -= {'Catering'}, Year =>}[OrderID] ),0,53))
      
      When the user selects Year, the first measure should change..but the second measure should remain unaffected
      
      as using the Year= in the set analysis
      
      the number for example before you select is
      
      for example weekend date is
      
      count 2216 (Measure 1)
      Avg 2586 (Measure 2)
      
      pick a year and I get
      
      count 2216 (Measure 1)
      Avg 2356 (Measure 2)
      
      I think it does not work well with rangeavg functions
      
      please help
      
      Like Show 0 Likes (0)
      
      Actions
      - Re: ignore selcetions qlik sense
        
        Sunny Talwar Sep 26, 2017 7:59 AM (in response to Joanna Seldon)
        
        Don't know my friend... sorry
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: ignore selcetions qlik sense
        
        Joanna Seldon Sep 26, 2017 8:01 AM (in response to Sunny Talwar )
        
        Hi
        
        is there another way / code type in qlik sense to ignore selections?
        
        I fount concat..but I don't think I am doing it right
        
        Kind Regards
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: ignore selcetions qlik sense
        
        Sunny Talwar Sep 26, 2017 8:03 AM (in response to Joanna Seldon)
        
        This is the only way it was introduced to me... I am unaware of another way... but may be someone else can help you
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: ignore selcetions qlik sense
        
        Joanna Seldon Sep 27, 2017 6:49 AM (in response to Sunny Talwar )
        
        Hi
        
        in a post you replied to
        
        3-months Average
        
        so I am now using the code you provided...
        
        RangeAvg(Below(Count( Distinct {1< Year=>} [OrderID]), 0, 52))
        
        I still need when a user selects a year from the filer pane , the measure is unaffected
        
        however using the Year= still does not work
        
        I have had to change the above code to Above instead of below..as the number will be slightly out otherwise too
        
        so it looks like
        
        RangeAvg(Above(Count( Distinct {1< Year=>} [OrderID]), 0, 52))
        
        any more ideas please
        
        Kind Regards
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: ignore selcetions qlik sense
        
        Sunny Talwar Sep 27, 2017 7:04 AM (in response to Joanna Seldon)
        
        Nope still no idea... I am really sorry Joanna.. I am not sure what you have at your end... and without knowing, it will be very difficult to say anything
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: ignore selcetions qlik sense
        
        Joanna Seldon Sep 27, 2017 7:18 AM (in response to Sunny Talwar )
        
        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
        
        Like Show 0 Likes (0)
        
        Actions

Go to original post