How to add alternate state inside Nested If statement

[Reko_freed]

I have a measure say - Sum({alternate_state_1}Amount), but in case of nested if , do I need to put {alternate_state_1} at each and every sum statement?

[vinieme12]

Yes you need to specify which set to use within each aggregation function

[RafaelBarrios]

Hi @Reko_freed 

Yes you would.

Also, According to your version, you could try the following

( {<Year={2021}>} nested if statement  with 2021 set  ) – Avg(CustomerSales)

https://community.qlik.com/t5/Design/New-Set-Analysis-syntax/bc-p/2003738#M9577

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!