Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

etrotter
Contributor II

Load Value by max Date

Hello,

I am trying to load Pay rate by max modification date, but it doesn't seem to be working correctly:

NoConcatenate

Compensation:

LOAD AgentID,

     Maxstring(ModificationDate) as ModificationDate,

     Max(PayRate) as PayRate

Resident Compensation_Temp

Group by AgentID;

I want one payrate per AgentID, here is the current output:

Capture.PNG

Let me know if you can help!

1 Reply
Digvijay_Singh
Honored Contributor III

Re: Load Value by max Date

Script is showing group By field AgentID but output is showing dimension as W_CODE, can you clarify. Also for date not sure why you have used MaxString instead of Max?If possible please share sample app to unnderstand it further.

Community Browser