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

      Q1.JPG

      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

      q2.JPG