6 Replies Latest reply: Nov 24, 2017 3:44 AM by Jonathan Dienst RSS

    Growth and filters

    Sofia Barbosa

      Hi all,

       

      I have a KPI in my dashboard in Qlik Sense that I would like that it changes as I select different filters (the half year with 2018 or quarter or month but all in 2018)

       

      the KPI refers to growth across time and looks like :

       

      ((sum({<[Year]={"2018"}>}Order)

      /

      sum({<[Year]={"2017"}>}Order)))-1

       

      unfortunately when I select a filter - the kpi just goes blank

      Could anyone help?

      many thanks

      Kind Regards

      Sofia