Discussion board where members can get started with Qlik Sense.
Can any one please help me on below requirement.
I have a table with all the dimensions
In Employee Name dimension I have to show only Max(Year) employees. I have tried like below
=if(Year =Max(Year), [Employee Name]) but getting invalid dimension in the table.
Please help me on this.
Thanks in advance.
Go to Solution.
MaxYear = max(Year)
=if(Year =$(MaxYear), [Employee Name])