topic Re: Subtraction between two measures in App Development https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/857#M64 <HTML><HEAD></HEAD><BODY><P>Great Chiara!!!!</P><P></P><P></P><P>Thank you!</P></BODY></HTML> Mon, 15 Jan 2018 16:51:46 GMT s_santalucia 2018-01-15T16:51:46Z Subtraction between two measures https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/846#M53 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P></P><P>I have this question for you:</P><P></P><P>I have two measures: P and S&nbsp; and, for one dimension, I must get the subtraction (P-S)&nbsp; but only S must be subdivided by another dimension.</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P>I hope for your help!</P><P>Thanks!</P></BODY></HTML> Mon, 15 Jan 2018 09:50:02 GMT https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/846#M53 s_santalucia 2018-01-15T09:50:02Z Re: Subtraction between two measures https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/847#M54 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>what do you mean by <STRONG>"</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>only S must be subdivided by another dimension."</STRONG> ?</SPAN></P></BODY></HTML> Mon, 15 Jan 2018 10:04:49 GMT https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/847#M54 YoussefBelloum 2018-01-15T10:04:49Z Re: Subtraction between two measures https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/848#M55 <HTML><HEAD></HEAD><BODY><P>can you post a sample ? </P><P></P><P><A href="https://community.qlik.com/thread/31487">How to get answers to your post?</A></P><P></P><P><A href="https://community.qlik.com/docs/DOC-7538">Qlik Community Tip: Posting Successful Discussion Threads</A></P></BODY></HTML> Mon, 15 Jan 2018 10:12:19 GMT https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/848#M55 vinieme12 2018-01-15T10:12:19Z Re: Subtraction between two measures https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/849#M56 <HTML><HEAD></HEAD><BODY><P>Hi Youssef Belloum,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; p&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; s</P><P><IMG alt="Image 2.png" class="jive-image image-1" src="/legacyfs/online/190080_Image 2.png" style="height: auto;" /></P><P style="margin-right: 4px;"></P><DIV style="margin-bottom: 8px;"><DIV><DIV class="gt-src-cc-normal cc-ctr" style="color: rgba(0, 0, 0, 0.54);"><P></P></DIV></DIV></DIV><P class="g-unit" style="color: #777777; font-family: arial, sans-serif; font-size: 13px;"></P><DIV style="margin: 0 0 8px; background: whitesmoke;"><DIV class="trans-verified-button-small" dir="ltr" style="padding: 8px;">S must be subdivided by the subgroup of the dimension, but P must not be subjected to this, it must always be the total subdivided by the main dimension and then P-S.</DIV><DIV class="trans-verified-button-small" dir="ltr" style="padding: 8px;">Thanks</DIV><DIV class="trans-verified-button-small" dir="ltr" style="padding: 8px;"><P></P></DIV></DIV></BODY></HTML> Mon, 15 Jan 2018 10:18:39 GMT https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/849#M56 s_santalucia 2018-01-15T10:18:39Z Re: Subtraction between two measures https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/850#M57 <HTML><HEAD></HEAD><BODY><P>Hi Vineeth </P><P></P><P>I published it in response to <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Youssef Belloum</SPAN></P></BODY></HTML> Mon, 15 Jan 2018 10:20:37 GMT https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/850#M57 s_santalucia 2018-01-15T10:20:37Z Re: Subtraction between two measures https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/851#M58 <HTML><HEAD></HEAD><BODY><P>can you also post the expected output?</P><P>in excel maybe!</P></BODY></HTML> Mon, 15 Jan 2018 10:24:30 GMT https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/851#M58 vinieme12 2018-01-15T10:24:30Z Re: Subtraction between two measures https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/852#M59 <HTML><HEAD></HEAD><BODY><P>Sorry i can't follow..</P><P></P><P>what do you mean by "subdivided" ?</P><P></P><P>what is the subgroup of the dimension ?</P><P></P><P>maybe you don't want to take what is after the comma of the field S for some lines ?</P></BODY></HTML> Mon, 15 Jan 2018 10:29:23 GMT https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/852#M59 YoussefBelloum 2018-01-15T10:29:23Z Re: Subtraction between two measures https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/853#M60 <HTML><HEAD></HEAD><BODY><P>Hi Vineeth,</P><P></P><P>here it is.</P></BODY></HTML> Mon, 15 Jan 2018 10:54:50 GMT https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/853#M60 s_santalucia 2018-01-15T10:54:50Z Re: Subtraction between two measures https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/854#M61 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have posted the file excel.</P><P></P><P>look that.</P></BODY></HTML> Mon, 15 Jan 2018 11:55:09 GMT https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/854#M61 s_santalucia 2018-01-15T11:55:09Z Re: Subtraction between two measures https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/855#M62 <HTML><HEAD></HEAD><BODY><P>hi Stefania,</P><P>try this</P><P><A href="https://community.qlik.com/message/1385236">Pivot table total as measurement</A></P></BODY></HTML> Mon, 15 Jan 2018 12:08:33 GMT https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/855#M62 c_pannese 2018-01-15T12:08:33Z Re: Subtraction between two measures https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/856#M63 <HTML><HEAD></HEAD><BODY><P>the table is clear ! just add the desired output on a new column</P></BODY></HTML> Mon, 15 Jan 2018 12:36:04 GMT https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/856#M63 YoussefBelloum 2018-01-15T12:36:04Z Re: Subtraction between two measures https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/857#M64 <HTML><HEAD></HEAD><BODY><P>Great Chiara!!!!</P><P></P><P></P><P>Thank you!</P></BODY></HTML> Mon, 15 Jan 2018 16:51:46 GMT https://community.qlik.com/t5/App-Development/Subtraction-between-two-measures/m-p/857#M64 s_santalucia 2018-01-15T16:51:46Z