Reference table (multiple match)

Thu, 28 Nov 2013 05:33:50 GMT

Have one driver table and want to reference based on one column and in reference table i have multiple records but i need to pick which is earlier (date), how can i achieve this, please need your suggestions.

Re: Reference table (multiple match)

er_mohit — Thu, 28 Nov 2013 05:46:31 GMT

Use firsorted value concept function for getting max record on the base of date and group by that one column

load * from orignial table;

load PrimaryKeyfield,

max(Recordfield) as Record,

firstsortedvalue(Datefield,-Record) as EarlierDate

resident originaltable

group by PrimaryKeyfield,;

topic Re: Reference table (multiple match) in QlikView

Reference table (multiple match)

Re: Reference table (multiple match)