Both mezzanine and pallet fill rate need to be assessed. As long as any rate is over 85%, the "Status" will become "Alert"; if any rate is over 92%, the Status will become "Overload".
How to create the column of "Status" by script or expression? I think "OR" is hard to realize in Qlik Sense.
The excel formular is IF(OR(E3>0.92,H3>0.92),"Overload",IF(OR(E3>0.85,H3>0.85),"Alert","Normal"))
| Daily Fill Rate Report |
|
| Week |
Date |
Mezzanine |
Total Mezzanine |
Mezzanine Fill Rate |
Pallet |
Total Pallet |
Pallet Fill Rate |
Status |
| 2023-WK1 |
1/3/2023 |
|
|
72.75% |
|
|
90.86% |
Alert |
| 2023-WK1 |
1/4/2023 |
|
|
73.28% |
|
|
91.65% |
Alert |
| 2023-WK1 |
1/5/2023 |
|
|
73.79% |
|
|
93.56% |
Overload |
| 2023-WK1 |
1/6/2023 |
|
|
74.16% |
|
|
90.01% |
Alert |
| 2023-WK2 |
1/9/2023 |
|
|
74.16% |
|
|
90.27% |
Alert |
| 2023-WK2 |
1/10/2023 |
|
|
86.59% |
|
|
77.66% |
Alert |
| 2023-WK2 |
1/11/2023 |
|
|
78.78% |
|
|
77.66% |
Normal |
| 2023-WK2 |
1/12/2023 |
|
|
79.60% |
|
|
90.09% |
Alert |
