15 Replies Latest reply: Jun 1, 2018 11:20 AM by Josh Akehurst RSS

    Set Analysis - Last 90 Days

    Josh Akehurst

      I'm attempting to use Set Analysis in Qlik Sense to filter a date range based on the last 90 days.  Using the expression below does not seem to have any effect.  I've tried various combinations, but just can't get anything to work.  The dimension in this scenario is Interaction Start Date Local. 

       

      =Avg({$<[Interaction Start Date Local]=${">=today()-90"}>}Duration)