4 Replies Latest reply: Sep 6, 2018 9:31 AM by Nagesh Setty RSS

    Date filters in Set Analysis

    Scott Allen

      Hello, Rookie question:


      I am trying to filter a measure in a KPI box using set analysis on a "date" field.  In the table, it shows up as right-aligned YYYY-MM-DD.  I tried the following:


      Sum(${< Year[Episode.NonAdmitDate]={2018},Month[Episode.NonAdmitDate]={'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug'},[Episode.IsNonAdmit]={1}>} [Episode.IsNonAdmit])


      I do not get an error, but none of the filters are working.  I also tried double quotes in the Month names.  I am using QlikSense Enterprise 3.0, and I do not have access to the binary load script.  Here is what the table looks like:


      NTUC table.JPG


      Any suggestions?  Thanks in advance for your help!!!