How to count straight table count function in Backend

[rkpatelqlikview]

Hi Qlik,

Can you explain how to write this expression in backend.

"=if(count(Delivery)>=30, 'Yes', 'No')"

Attached file exported from Straight table.

[Qrishna]

You have already calculated a field to check count(Delivery)>=30 or not.

simply use that field again to populate 'yes' or 'no' in other field.

see below

Load *,

[Field1='controlled','Yes', 'No')] as Field1;

LOAD MnsTrnspID,

    [=if(count(Delivery)>=30, 'controlled', 'Noncontrolled')] as Field1

FROM

(ooxml, embedded labels, table is Sheet1);

[adityaakshaya]

Hi Kumar,

As per my understanding, you want t implement the logic as straight table in your backend. You have to use group by while loading the data. I am attaching the example for your reference.

Let me know for any further clarification.

Regards,

Akshaya

PS - If you find this solution correct, then mark it as Correct or helpful.