Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Current Year selection

Hi Team,

I have Fiscal Year like : 2020-2021, 2021-2022.

Now I my expression is like  - SUM({$<FiscalYear={"2021-2022"}>} FHC) 

I don't want hard code of year.

I tried by using variable, But My variable is not working. In my Script I have used for this fiscal Year =

Num#(YearName(Link_Date, 0, 4)) AS FiscalYear

Please suggest how I can make the expression for current fiscal year.

Thanks.

Labels (2)
0 Replies