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
