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: 
cliff_clayman
Creator II
Creator II

How do I convert this expression using Set Analysis adding in a condition for Year?

I have the following expression I would like to convert to Set Analysis and add a condition:

=(Sum([Budget])/Count([Budget]))

I need to add a condition for Year.  The condition would be for current year which I have a variable for.

vFY is the name of the variable. So, Year=vFY

How can I convert this to Set Analysis and add this condition?

Labels (2)
1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

=(Sum({$<Year={'$(=$(vFY))'}>}[Budget])/Count([Budget]))

View solution in original post

1 Reply
jwjackso
Specialist III
Specialist III

=(Sum({$<Year={'$(=$(vFY))'}>}[Budget])/Count([Budget]))