Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

dpreobrazh
New Contributor II

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

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

1 Reply
dpreobrazh
New Contributor II

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

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