6 Replies Latest reply: Apr 11, 2016 10:35 AM by Mark Ritter RSS

    Set Analysis Help

    Mark Ritter

      This should be simple.  But I can't figure it out in Qlik Sense.

       

      I have created an Inline table with 2 values for the Year (2015,2016).

       

      I want to put Set Analysis on my charts to only show data where the Year of the field I am using is equal to the choice made from this listbox.  YearValue is the Inline table value from above (2015, etc.) that I created.

       

      So far everything that I have tried is not working.

       

      This is one example of something that I have tried:

       

      Count({< Year(CreatedDateTime) = {$(YearValue)} >} IncidentNumber)

       

      Any help would be greatly appreciated