Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik,
Can you explain how to write this expression in backend.
"=if(count(Delivery)>=30, 'Yes', 'No')"
Attached file exported from Straight table.
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);
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.