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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register 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])