6 Replies Latest reply: Jun 21, 2017 4:19 PM by Steve Holmes RSS

    More Set Analysis, I think

    Steve Holmes

      I use Qlik Sense in a healthcare unit, providing analysis of trauma events.  We use KPIs in a number of areas - average or median time from admission to CT scan, for example.  I chart this using line charts: years on the X axis and hours on the Y axis.  The data is grouped by district health board (DHB).

       

      I'd like to provide the same data, but instead of 5 DHBs I want to show an individual DHB's average plus an average for all five DHBs - so two lines on the chart; one will be coloured for the DHB, and the other grey for the average.  (I can do the colours.)

       

      Can anybody tell me how to make an "all" group and one for the individual DHB?

       

      Thanks for your advice!

       

      Steve