11 Replies Latest reply: Jul 5, 2017 3:33 AM by MaheshKumarCV Default RSS

    Qlik Sense : How to restrict graph for 5 years

    MaheshKumarCV Default

      Expression :


      rangesum( below( count({  < EMP_HRIS = {"E"} >} [Emp Code]), 0, FYEAR))


      count({<EMP_HRIS = {"L"} >} [Emp Code] )


      Dimension : FYEAR


      In the above graph I want to restrict to view only for 5 years ,


      As my count is accumulating year wise , if I restrict at dimension (Year) level some data is missing see below screen shot.


      Dimension :


      =if(FYEAR>=max(total FYEAR-5),FYEAR)


      Using same Expression


      Now it’s showing wrong values