topic AGGR() or FIRSTSORTEDVALUE() - Help? in QlikView

AGGR() or FIRSTSORTEDVALUE() - Help?

Tue, 04 Nov 2014 08:44:41 GMT

I need some help storing a flag for a oldest date with a minimum value.

This is my data. I need a flag that will give me the OLDEST Date where Hours<MinHours for any Staff member.

The flag value in the bottom data should then be 01/11/2014.

morganaaron — Tue, 04 Nov 2014 08:53:06 GMT

Do you need the flag for each Staff member, or just one value overall?

If you need one value you could use: Date(Min(If(Hours<MinHours,Date,)))

jagan — Tue, 04 Nov 2014 09:16:53 GMT

Hi,

Try like this in script

LOAD

Date(Min(Date)) AS OLDEST_Date

FROM DataSource

WHERE Hours < MinHours;

Or in front end

Date(Min(Aggr(If(Hours < MinHours, Date), Staff, Date, Hours, MinHours)))

Hope this helps you.

Regards,

Jagan.

Tue, 04 Nov 2014 09:21:13 GMT

thanx that worked, i just changed the min/date at the front

Tue, 04 Nov 2014 09:28:08 GMT

Thanx alot, that script just saved me, so simple but so effective