If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
MaxYear = max(Year)
=if(Year =$(MaxYear), [Employee Name])
View solution in original post