topic Preceding Load Nested if statement issue in QlikView

Preceding Load Nested if statement issue

gangelep — Mon, 26 Jan 2026 18:19:17 GMT

I want Status of each Shipment ID so i have used nested IF statement in preceding load.

I am using Straight table but getting two rows against some ShipmentID.

I don't want to use "Suppress when value is null" due to some specific business condition.

Could you please help me out here why i am getting blank status row here

LOAD ShipmentID,
If(Loading_Time < Start,'Early',
If(Loading_Time>Stop,'Late',
If(Loading_Time>Start and Loading_Time < Stop,'On Time'))) As Status;
Load *,
Time([PL time]-Buffer_Early,'hh:mm') as Start,
Time([PL time]+Buffer_Late,'hh:mm') as Stop;
Load *
Resident Shipment;

Re: Preceding Load Nested if statement issue

HirisH_V7 — Sun, 10 May 2020 07:56:30 GMT

Sample Data and required output .. will give clear idea.

Re: Preceding Load Nested if statement issue

Brett_Bleess — Thu, 04 Jun 2020 13:38:30 GMT

My best hunch would be you have a result that is not meeting your condition in the If statements, i.e. things are equal maybe, and therefore we do not know what status to apply. Only way of which I can think to prove that is to cover that in the If statement by adding a final result of some other value if no other conditions are met. So what I am saying is a final 'else' along the lines of something that will flag we have a condition that is not being met...

Regards,
Brett