1 Reply Latest reply: Oct 18, 2017 6:16 PM by Dmitriy Preobrazhenskiy RSS

    How to Build KPI(s) on dashboard by using only one field

    Dmitriy Preobrazhenskiy

      Hello,

       

      I have the field [CompletionStatusDaysPstDue] in table:

       

       

      CompletionStatusDaysPstDue

      -------------------------

      Completed

      Completed

      52

      Completed

      52

      Completed

      -1

      -10

      0

      2

      3

      14

      7

      52

      52

      52

      52

      52

       

       

      * Notes: Numbers showing how many day left until Due Date to complete training. Negative number is OverDue. "Completed" means training completed.

       

       

      I want to build KPI on dashboard as:

      Completed   White    Green   Yellow   Orange    Red

      4                    7           1           2           2                2

       

       

      The Logic is:

      if ([CompletionStatusDaysPstDue]='Completed', 'Completed',

      if ([CompletionStatusDaysPstDue]<0, 'Red',

      if ([CompletionStatusDaysPstDue]>=0 and [CompletionStatusDaysPstDue]<3 ,'Orange',

      if ([CompletionStatusDaysPstDue]>=3 and [CompletionStatusDaysPstDue]<7 ,'Yellow',

      if ([CompletionStatusDaysPstDue]>=7 and [CompletionStatusDaysPstDue]<15 ,'Green',

      'White')))))

       

       

      I'm new in QlikSense and any help will appritiate. I don't have Desktop, we use Qlik Sense Enterprise and my role user.

       

      Best Regard,

      DMI