7 Replies Latest reply: May 8, 2018 7:55 AM by Henric Cronström RSS

    How to find Inter-Quartile range for specific value in Qlik Sense

    Vivek Anand

      Hi all,

      I want to find the Inter-Quartile range for data(GAMES_MISSED) for 2012 - 2016.

      Here I have attached the data


      As of now I'm using the formula:-

      fractile({<[SEASON-Year]={'2016'}>}NBA_GAMES_MISSED,0.25) AND fractile({<[SEASON-Year]={'2012'}>}NBA_GAMES_MISSED,0.25)


      But I'm not getting the correct output

      Please check and tell me how to do this?