topic Re: Restrict the dates in load script in QlikView

Restrict the dates in load script

0li5a3a — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Could someone help me to display only the

ID, DATE, MESSAGE

1,10/11/2012 12:00:56, YES

1,10/11/2012 12:04:43, NO

1,10/11/2012 13:10:02,YES

2,113/11/2012 13:11:02,YES

2,11/11/2012 13:15:02,YES

2,12/11/2012 14:20:02,YES

And I want to create something like this:

ID, DATE, MESSAGE

1, 10/11/2012 13:10:02, YES,

2, 12/11/2012 14:20:02, YES

I need only the last time when ticket was updated to be displayed in a streight table.

I tried to use the Max(DATE) in the chart to sort them but I want to restrict the data from the load script. Any advises?

Thansk in advance!

Re: Restrict the dates in load script

sunny_talwar — Mon, 06 Nov 2017 14:18:13 GMT

May be this

Fact:

LOAD ID,

DATE,

MESSAGE

FROM ....

Right Join (Fact)

LOAD ID,

Max(DATE) as DATE

Resident Fact

Group By ID;

Re: Restrict the dates in load script

jpenuliar — Mon, 06 Nov 2017 14:28:32 GMT

LOAD * Inline

[

ID, DATE, MESSAGE

1,10/11/2012 12:00:56, YES

1,10/11/2012 12:04:43, NO

1,10/11/2012 13:10:02,YES

2,13/11/2012 13:11:02,YES

2,11/11/2012 13:15:02,YES

2,12/11/2012 14:20:02,YES

];

FirstSortedValue:

LOAD ID,

FirstSortedValue(DATE, -DATE) as Date,

FirstSortedValue(MESSAGE, -DATE) as Message Resident A Group By ID;

Re: Restrict the dates in load script

0li5a3a — Mon, 06 Nov 2017 15:35:03 GMT

Thanks for it, works now using this