topic Re: Find average where variables are defined in QlikView

topic Re: Find average where variables are defined in QlikView https://community.qlik.com/t5/QlikView/Find-average-where-variables-are-defined/m-p/1369773#M418759 <HTML><HEAD></HEAD><BODY><P>Like this:</P><P></P><P>=<EM>Avg({<B = {1}, C = {2}>} A)</EM></P></BODY></HTML> Wed, 12 Jul 2017 09:32:15 GMT jonathandienst 2017-07-12T09:32:15Z Find average where variables are defined https://community.qlik.com/t5/QlikView/Find-average-where-variables-are-defined/m-p/1369772#M418758 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Hello</P><P style="text-align: left;"></P><P style="text-align: left;">I am looking to find the average of a field where two other fields are defined</P><P style="text-align: left;"></P><P style="text-align: left;">i.e.</P><P style="text-align: left;">Avg(A)({<<B> = {'1'}, <C> = {'2'}>} <D>)</D></C></B></P><P style="text-align: left;"></P><P style="text-align: left;">Find the average of A where B = 1 and C = 2</P><P style="text-align: left;"></P><P style="text-align: left;"></P><P style="text-align: left;">Thank you</P></BODY></HTML> Wed, 12 Jul 2017 09:30:18 GMT https://community.qlik.com/t5/QlikView/Find-average-where-variables-are-defined/m-p/1369772#M418758 Anonymous 2017-07-12T09:30:18Z Re: Find average where variables are defined https://community.qlik.com/t5/QlikView/Find-average-where-variables-are-defined/m-p/1369773#M418759 <HTML><HEAD></HEAD><BODY><P>Like this:</P><P></P><P>=<EM>Avg({<B = {1}, C = {2}>} A)</EM></P></BODY></HTML> Wed, 12 Jul 2017 09:32:15 GMT https://community.qlik.com/t5/QlikView/Find-average-where-variables-are-defined/m-p/1369773#M418759 jonathandienst 2017-07-12T09:32:15Z