topic Set analysis in text object in QlikView

Set analysis in text object

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I would like to add Round_Type = {Qualifier}

To this text box expression:

=round(sum(Score)/Count(Round_Id))& ' Team Average Overall'

Re: Set analysis in text object

Anonymous — Thu, 08 Mar 2018 01:11:03 GMT

So, if Round_Type = 'Qualifier'

round(sum(Score)/Count(Round_Id

Essentially the average score when round is qualifier - in a text object.

Re: Set analysis in text object

Qrishna — Thu, 08 Mar 2018 01:38:34 GMT

=round(sum({$<Round_Type = {Qualifier}>}Score)/Count({$<Round_Type = {Qualifier}>}Round_Id)) & ' Team Average Overall'

Re: Set analysis in text object

Anonymous — Thu, 08 Mar 2018 02:02:53 GMT

No, the average is still overall, still the result of:

=round(sum(Score)/Count(Round_Id))

Re: Set analysis in text object

shilpan — Thu, 08 Mar 2018 02:04:18 GMT

=round(sum({$<Round_Type = {'Qualifier'}>}Score)/Count({$<Round_Type = {'Qualifier'}>}Round_Id)) & ' Team Average Overall'

Re: Set analysis in text object

Anonymous — Thu, 08 Mar 2018 02:14:50 GMT

I think that is exactly the same as Krishna's reply, and the output is the same as well - still the overall average without the Round_Type qualification of 'Qualifier'

Re: Set analysis in text object

prma7799 — Thu, 08 Mar 2018 03:40:45 GMT

= Round(sum({$<Round_Type = {'Qualifier'}>}Score)

Count({$<Round_Type = {'Qualifier'}>}Round_Id)) & ' Team Average Overall'

Re: Set analysis in text object

Anonymous — Thu, 08 Mar 2018 14:29:35 GMT

Bingo! Thank you very much. Interesting I think I went down this road and got tripped up by the fact the syntax was not being highlighted correctly as the expression was being written. I should have known to just keep plowing on - despite the fact QV does not always highlight as one might expect, it often winds up with "Expression OK" when finished...