Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Reko_freed
Contributor III
Contributor III

How to add alternate state inside Nested If statement

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?

Labels (2)
2 Replies
vinieme12
Champion III
Champion III

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

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
RafaelBarrios
Partner - Specialist
Partner - Specialist

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!