topic Count record number in a single feild in QlikView

Count record number in a single feild

AkbarShaikh — Tue, 17 Mar 2020 12:39:07 GMT

Hello Guys,
I need to limit records of a field in the script with an IF function to create a boolean statement.
example:
IF (Ordervalue = 'MET' AND (Order_number <= '15'), '1', '0') as Parameter
The challenge is that I am not able to limit the number of records from Order_number field.
Is there any way that I can limit this field to give only 15 records in the script?

Regards,

Re: Count record number in a single feild

sunny_talwar — Tue, 17 Mar 2020 12:42:19 GMT

Not sure I understand your issue? You want to bring only those records where Ordervalue = MET and Order_number value is less than 15?

Re: Count record number in a single feild

AkbarShaikh — Tue, 17 Mar 2020 12:45:52 GMT

Yes Sunny, those two parameters are required to calulate the SLA

Re: Count record number in a single feild

AkbarShaikh — Tue, 17 Mar 2020 13:39:02 GMT

//Solution:

Load Table 1

Then Load Table 2 (Record Number) with a Resident Load from Table 1 with a where clause.

//Script:

Table2:

NoConcatenate

Load *,

REC NO () as field_name

Resident Table 1 WHERE Order_number = 1; // Order_number is the unique field availible in Table 1

DROP TABLE 1;

//END OF SCRIPT