Discussion board where members can get started with Qlik Sense.
I have this table:
I would like to only show the Base Rate from the most recent Compensation_Effective_Date. I have tried with a where statement, a lastvalue functions, but I have yet to get either of them to work.
I'd appreciate if you could help, thanks in advance!
Go to Solution.
Right Join (Temp)
Max(Compensation_Effective_Date) as Compensation_Effective_Date
Group By Worker_ID;