Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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]))