topic Re: Calculations between subgroups of a dimension in App Development https://community.qlik.com/t5/App-Development/Calculations-between-subgroups-of-a-dimension/m-p/1287737#M27110 <HTML><HEAD></HEAD><BODY><P>And how are the values Real 2016/2015 and budget 2016/2015 calculated? The value of responses you get will be directly proportional to the amount of information you provide.</P></BODY></HTML> Tue, 22 Nov 2016 13:39:33 GMT jonathandienst 2016-11-22T13:39:33Z Calculations between subgroups of a dimension https://community.qlik.com/t5/App-Development/Calculations-between-subgroups-of-a-dimension/m-p/1287733#M27106 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I currently have my 2016 Data, budget and past years in a dimension called Origin.</P><P>Im using a pivot table to see results,but i want to make calculations between this fields.</P><P>Any Clues?</P><P><IMG alt="example.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144450_example.jpg" style="height: auto;" /></P></BODY></HTML> Tue, 22 Nov 2016 04:25:13 GMT https://community.qlik.com/t5/App-Development/Calculations-between-subgroups-of-a-dimension/m-p/1287733#M27106 2016-11-22T04:25:13Z Re: Calculations between subgroups of a dimension https://community.qlik.com/t5/App-Development/Calculations-between-subgroups-of-a-dimension/m-p/1287734#M27107 <HTML><HEAD></HEAD><BODY><P>It might be useful if you provided some clues on what you would like to calculate...</P></BODY></HTML> Tue, 22 Nov 2016 04:49:23 GMT https://community.qlik.com/t5/App-Development/Calculations-between-subgroups-of-a-dimension/m-p/1287734#M27107 jonathandienst 2016-11-22T04:49:23Z Re: Calculations between subgroups of a dimension https://community.qlik.com/t5/App-Development/Calculations-between-subgroups-of-a-dimension/m-p/1287735#M27108 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>you can make calculation between this fields by using the before() function :</P><P></P><P>mesure :</P><P>may be : </P><P>sum(MONTO MILES) - before(sum(MONTO MILES))</P></BODY></HTML> Tue, 22 Nov 2016 13:03:39 GMT https://community.qlik.com/t5/App-Development/Calculations-between-subgroups-of-a-dimension/m-p/1287735#M27108 brunobertels 2016-11-22T13:03:39Z Re: Calculations between subgroups of a dimension https://community.qlik.com/t5/App-Development/Calculations-between-subgroups-of-a-dimension/m-p/1287736#M27109 <HTML><HEAD></HEAD><BODY><P>@</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P><A _jive_internal="true" data-avatarid="2417" data-externalid="" data-online="false" data-presence="null" data-userid="13229" data-username="jontydkpi" href="https://community.qlik.com/people/jontydkpi" style="font-weight: bold; font-style: inherit; font-family: inherit; color: #8b8b8b;">Jonathan Dienst</A> (a <A _jive_internal="true" data-avatarid="5408" data-externalid="" data-online="false" data-presence="null" data-userid="233345" data-username="abel1982" href="https://community.qlik.com/people/abel1982" style="font-weight: bold; font-style: inherit; font-family: inherit; color: #8b8b8b;">abel abad</A>)<SPAN class="j-act-time font-color-meta-light" style="padding: 0 0 0 5px; font-weight: inherit; font-style: inherit; font-family: inherit;"> <A _jive_internal="true" class="font-color-meta-light" href="https://community.qlik.com/message/1163453#1163453" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #a9a9a9;">hace 9 horas</A></SPAN></P> <P style="font-weight: inherit; font-style: inherit; font-family: inherit;">It might be useful if you provided some clues on what you would like to calculate...</P> <P></P> <P></P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Im just looking to make this formulas :</P><P>Real 2016 / Budget 2016</P><P>Real 2016-Budget 2016</P><P>Real 2016 / Real 2015</P></BODY></HTML> Tue, 22 Nov 2016 13:31:06 GMT https://community.qlik.com/t5/App-Development/Calculations-between-subgroups-of-a-dimension/m-p/1287736#M27109 2016-11-22T13:31:06Z Re: Calculations between subgroups of a dimension https://community.qlik.com/t5/App-Development/Calculations-between-subgroups-of-a-dimension/m-p/1287737#M27110 <HTML><HEAD></HEAD><BODY><P>And how are the values Real 2016/2015 and budget 2016/2015 calculated? The value of responses you get will be directly proportional to the amount of information you provide.</P></BODY></HTML> Tue, 22 Nov 2016 13:39:33 GMT https://community.qlik.com/t5/App-Development/Calculations-between-subgroups-of-a-dimension/m-p/1287737#M27110 jonathandienst 2016-11-22T13:39:33Z