Discussion Board for collaboration on QlikView Scripting.
i have this situation
i NEED TO LOAD IF IS NULL WITH WHERE BUT SOME TIMES ORIGNAL DATA IS BAD.
How to load only the last null ??
please could you explain the rule to identify nulls?
or mark the records you want to load?
i need load all records.
i have not rule. some records has more than one null (data base is wrong)
if i has 2 null the las is the valid the other is from-1.
10/01/2012 null(14/05/2012 will be)
I think you have to load the data in descending order by id and from date
Then you could work with previous() function to get the 'from' to fill the 'to' in current record when null, only do this when id is the same (id = previous(id)).
Could this help?