Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joshpinfold
New Contributor III

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])

Tags (1)
2 Replies
ali_hijazi
Honored Contributor

Re: Fields within Set Analysis

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

or

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

shraddha_g
Honored Contributor III

Re: Fields within Set Analysis

not so sure but

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