Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 (3)
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]))