topic Field content according last date in QlikView

Field content according last date

Wed, 20 Nov 2013 10:31:25 GMT

Hi everybody,

here is a simple problem (i'm sure) i can't solve.

I want to display the status corresponding to the last date for each Name

Aggr function seems to give the right result but ONLY if status are the same.

My goal is to fill Status with the value according the last date

Thank you for your help

best regards

chris

jerem1234 — Wed, 20 Nov 2013 15:23:37 GMT

Do u want as expression or calculated dimension?

For expression and with Name as a Dimension, any one of these expressions should do the job:

=firstsortedvalue(Status,-Date)

=subfield(concat(Status,'|',-Date),'|',1)

=Concat(IF(aggr(Rank(Date),Name,Date)=1,Status))

If you want as calculated dimension with Name as Dimension:

=IF(aggr(Rank(Date),Name,Date)=1,Status)

Hope this helps!

MayilVahanan — Wed, 20 Nov 2013 15:52:47 GMT

Try like this

=firstsortedvalue(Status,-Date)