Includes all Year Sales when User selects only Current Year.

[MuraliPrasath]

Hi Qlik,

I have Year filter which shows Years from 2021 to 2023 (Current Year).

My requirement is to show SalesKPI in the below scenario. 

• If User selects Current Year (2023) then it should show all the Years Sales. 
• If User selects Other than Current Year then that particular Year Sales only should show. Can you help me on this?
•  
• 

[anat · Accepted solution]

If(getfieldselection(FY) =year(today()), sum({<FY=>}sales) , sum(sales)) 

[anat]

Bypass the FY selection if selected year is current year else show the data as per selection

[MuraliPrasath]

Thank you 🙂 That worked perfectly. 😀