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

      Michael