Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Fields within Set Analysis

I am calculation the average score but also have a check that the Survey_date and SendDate are the same. I know the first part of the set analysis but it is the Survey_date part which is causing the error. Both Survey_date and SendDate are both fields.

Avg({<FFMessage={'Score - Sales investigation'}, Survey_date={"=$(=SendDate)"}>}[Given Score])

2 Replies
ali_hijazi
Partner - Master II
Partner - Master II

avg({<FFMessage={'Score - Sales investigation'}>}if(Survey_date=SendDate,GivenScore))

or

avg({<FFMessage={'Score - Sales investigation'},Key_Column={"=Survey_date=SendDate"}>}GivenScore)

I can walk on water when it freezes
shraddha_g
Partner - Master III
Partner - Master III

not so sure but

Avg({<FFMessage={'Score - Sales investigation'}, Survey_date = p(SendDate)>}[Given Score])