Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

If logic help

Hi Experts,

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.

1 Solution

Accepted Solutions
ChennaiahNallani
Creator III
Creator III

Variable

MaxYear = max(Year)

Exp..

=if(Year =$(MaxYear), [Employee Name])

View solution in original post

1 Reply
ChennaiahNallani
Creator III
Creator III

Variable

MaxYear = max(Year)

Exp..

=if(Year =$(MaxYear), [Employee Name])