Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Yes you need to specify which set to use within each aggregation function
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!