Resident Load where the sum is zero

[QS_]

I'm trying to do a resident load to a new table data for those days where the cost (i.e. sum of all rows of the day) is zero. 

I tried doing this with the script below.

Table2:

Load *

Resident Table1 where Len(cost)=0;

However, Table2 contains rows with zero cost on non-zero total cost days. Is there a way to do conditional load where sum(cost) ordered by date is zero?

[ajaykakkar93]

Hi,

I have some solutions some basic checks & questions

1. Do you have data for the day in the raw data file or table?
2. If you do have the data is it coming in Number or String format?
3. If it is in a number format please convert the field to number by using Num(num#(FIELD)) as FIELD_NAME
4. this could fix your issue, make sure you first get rid of the where condition & check you data in qlik also
5. simple steps to understand the COST field is in string or number 
   1. load the data without where
   2. create a table in qlik frontend
   3. add the field COST as Dimension
   4. If the data is on the left, it is in a string; if on the right, it is a number.
   5. If the field is a string, use num(Num#(trim(FieldName))) to convert it to a number in the same dimension. This will help you determine if it is working.
   6. When applying the same backend, this will work. However, if the issue still persists, I suggest that you please share a sample file. This will provide more clarity.