7 Replies Latest reply: May 7, 2018 2:47 AM by Vivek Anand RSS

    How to include zero or null values in Fractile() in Qlik Sense

    Vivek Anand

      Hi all,

      I'm using a fractile() where I'm getting a different result that is not equal to expected one.

      My expression is like this:-

       

      fractile({<year={'2012','2013','2014','2015'}>}Sales,.25)


      there are some null or blank or zero values in year filed like sales(2013)=0 or sales(2014)=0 and so on...

      that's why I'm getting the exact result.

      I think this expression is not including the zero or something

      So How can I include the zero values in Fractile()?