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

Anonymous — Wed, 18 Oct 2017 21:44:28 GMT

Hello,

I have the field [CompletionStatusDaysPstDue] in table:

CompletionStatusDaysPstDue

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

Completed

-1

-10

* 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

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

Anonymous — Wed, 18 Oct 2017 22:16:17 GMT

I think needs to create additional field and use all logic with IF statements...but how it will help to build KPI?