Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

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
Contributor III

Re: If logic help

Variable

MaxYear = max(Year)

Exp..

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

1 Reply
ChennaiahNallani
Contributor III

Re: If logic help

Variable

MaxYear = max(Year)

Exp..

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