topic Re: How to find latest year from 'YY/YY' format in App Development

How to find latest year from 'YY/YY' format

MZqlik — Fri, 01 Jul 2022 18:35:01 GMT

Hi Everyone.
I have a field "financial year" which is in the following format: 21/22, 22/23 ('YY/YY').
I want to create a variable which identifies which one is the latest year (max) so that every year I don't have to update it manually. Does anybody have a clue if this can be done in this format or shall I covert the date format from the source data?
Thank you

Year field is literally:

'21/22'

'22/23'

How to find latest year from 'YY/YY' format

MZqlik — Fri, 01 Jul 2022 15:03:49 GMT

Re: How to find latest year from 'YY/YY' format

sidhiq91 — Fri, 01 Jul 2022 15:35:38 GMT

@MZqlik Could you please provide us the sample data so that we can help you out?

Re: How to find latest year from 'YY/YY' format

MZqlik — Fri, 01 Jul 2022 18:32:38 GMT

I don't think there is much to share to be honest.

Year field is literally:

'21/22'

'22/23'

I would like to identify the latest with the set analysis.

Re: How to find latest year from 'YY/YY' format

MZqlik — Fri, 01 Jul 2022 18:37:05 GMT

Apologies I meant to post this into Qlik Sense. I have just done it, feel free to remove this post.

Re: How to find latest year from 'YY/YY' format

Or — Fri, 01 Jul 2022 19:02:25 GMT

MaxString([Financial Year]) should work here. If your max year in the example above is '23', use Right(MaxString([Financial Year]),2).

Re: How to find latest year from 'YY/YY' format

MZqlik — Mon, 04 Jul 2022 08:09:16 GMT

Perfect that does the job. Thank you!