topic Re: Limit results in a new field in my script in QlikView

Limit results in a new field in my script

Thu, 17 Aug 2017 14:02:05 GMT

I have added a new field in my script (days_overdue) , I wanting to limit the results so that it only show number of days over '0'.

This is my script so far:

LOAD [Person Ref],

[Child Name],

DoB,

Gender,

Ethnicity,

Disability,

[Legal Status],

[Lead Professional],

Team,

[Start Date],

[End Date],

[Target Date],

[Target Date Amended?],

[Due Within 5 Days?],

num(today()-[Target Date]) as days_overdue,

Overdue?

FROM

Re: Limit results in a new field in my script

Anil_Babu_Samineni — Thu, 17 Aug 2017 15:38:24 GMT

You could arrange all date formats is same. Then only it works. Even, Don't require to use Num() here

Re: Limit results in a new field in my script

vishsaggi — Thu, 17 Aug 2017 15:42:49 GMT

May be this? Do a preceding load.

LOAD *

WHERE days_overdue > 0;

LOAD [Person Ref],

[Child Name],

DoB,

Gender,

Ethnicity,

Disability,

[Legal Status],

[Lead Professional],

Team,

[Start Date],

[End Date],

[Target Date],

[Target Date Amended?],

[Due Within 5 Days?],

num(today()-[Target Date]) as days_overdue

FROM YoursourceTable;

Re: Limit results in a new field in my script

Peter_Cammaert — Thu, 17 Aug 2017 16:25:37 GMT

I guess you don't want to know about invoices that aren't overdue in a field that shows the number of days overdue? Then you could use a minor expression modification that removes all negative days_overdue values:

max(num(today()-[Target Date]), 0) as days_overdue,

Best,

Peter

Re: Limit results in a new field in my script

Fri, 18 Aug 2017 14:42:19 GMT

Thank you everyone who has replied to me, my script now works.

Thanks again

Re: Limit results in a new field in my script

Peter_Cammaert — Mon, 21 Aug 2017 09:58:43 GMT

If your problem has been solved, please close the discussion by marking reponses as HelpFul and Correct. That way, other community members will know that there is a solution to be found here to a problem they may have encountered themselves.

Thanks.