3 Replies Latest reply: Sep 13, 2017 3:19 PM by Michael Simonsen RSS

    Set expressions

    Michael Simonsen

      Hi Qlik'ers


      I have a KPI chart that shows the sum of Sales in years >= 2014 in US region


      sum({<Region = {US}, Year = {'>= 2014'}>} Sales)


      But if I filter on Year = 2015 I want the KPI to sum only on Year = 2015, and not all the years 2014, 2015, 2016, 2017.

      My data also contain years before 2014, but I do not want to include them in the sum.

      How can I do that?

      Best regards