Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team, I have field named "Year" There is one field value FY 2020-2021 H1. I want to get only Numeric that in this format 121 i.e H1's 1 should come first and then 21 should come. Is this possible in qlik. This is the urgent requirement please help.
=right(Year, 1) & mid(Year, 12, 2)
-Rob