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

Use If statement in Set Analysis

Hi,

I want set fiscal year depending fiscal actual month in set analysis expression but it doesn't work.

Here you are the expression i'm using:

=Sum({<Anio={"$(=If(Num(Month(Today()))=10, Max(Anio)-1, Max(Anio)))">} Amount)

Can Anyone help me?

10 Replies
Anil_Babu_Samineni

The reason i am asking you is i am not clear with that expression. Would you share atleast data set and may be helpful to you if you know the result set as well. Please post on wall if possible

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful