Discussion board where members can get started with Qlik Sense.
I am trying to load Pay rate by max modification date, but it doesn't seem to be working correctly:
Maxstring(ModificationDate) as ModificationDate,
Max(PayRate) as PayRate
Group by AgentID;
I want one payrate per AgentID, here is the current output:
Let me know if you can help!
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.