Fill Rate Status Calculation

[My_Rebecca]

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

[My_Rebecca]

Dear @sandeep-singh , I have change this chart from KPI to Button, then the "OR" could be realized with changeable color setting.