Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Dear @sandeep-singh , I have change this chart from KPI to Button, then the "OR" could be realized with changeable color setting.