Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

poojashribanger
Contributor II

problem in max(Fiscalyear)

Hi,

I have table like this

FiscalYear

2016-2017

2017-2018

when i am trying below expression i am getting 26

previously it was working fine.

right(max(FiscalYear),2)

it should give me 18 i.e my max(fiscalyear) is FY18

Please help.

i have attached image

1 Solution

Accepted Solutions
MVP
MVP

Re: problem in max(Fiscalyear)

May be try this

Right(MaxString(FiscalYear), 2)

1 Reply
MVP
MVP

Re: problem in max(Fiscalyear)

May be try this

Right(MaxString(FiscalYear), 2)

Community Browser