2 Replies Latest reply: Jul 26, 2017 12:43 PM by Conrad Theart RSS

    Selections with Set Analysis

    Conrad Theart

      Hi all,

       

      I've got the following expression in Qlik sense to show years over months in a line chart:

       

      Sum({$<TS_year={2013}>}(TS_hoursWorked))

       

      This works fine, but if a user selects a year other that 2013, I want 2013 to disappear.

       

      I've tried a if statement, but this doesn't work for a chart. With a if statement it only shows when the coded year is selected.

       

      Any ideas?

       

      Thanks,

      Conrad