topic Re: How to count straight table count function in Backend in QlikView

How to count straight table count function in Backend

rkpatelqlikview — Tue, 01 May 2018 14:01:46 GMT

Hi Qlik,

Can you explain how to write this expression in backend.

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

Attached file exported from Straight table.

Re: How to count straight table count function in Backend

Qrishna — Tue, 01 May 2018 14:22:22 GMT

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);

Re: How to count straight table count function in Backend

adityaakshaya — Tue, 01 May 2018 14:32:44 GMT

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.