topic Subtract 2 expression in QlikView https://community.qlik.com/t5/QlikView/Subtract-2-expression/m-p/1372314#M820552 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> H</SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">i Community</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Is there any way to subtract two expression on one dimension?</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> F</SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">or example:</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="mso-bidi-font-family: Arial; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; line-height: 107%; color: #000000; font-size: 11pt; mso-hansi-theme-font: minor-latin; mso-ansi-language: EN-US; font-family: 'Calibri',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-bidi-theme-font: minor-bidi;">I want to know how many personnel are decreased / increased base on 2017/01 or 2017/02 , .....</SPAN></P><P><SPAN style="mso-bidi-font-family: Arial; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; line-height: 107%; color: #000000; font-size: 11pt; mso-hansi-theme-font: minor-latin; mso-ansi-language: EN-US; font-family: 'Calibri',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-bidi-theme-font: minor-bidi;"> Regard</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT apegahfar 2020-11-25T16:16:04Z Subtract 2 expression https://community.qlik.com/t5/QlikView/Subtract-2-expression/m-p/1372314#M820552 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> H</SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">i Community</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Is there any way to subtract two expression on one dimension?</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> F</SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">or example:</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="mso-bidi-font-family: Arial; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; line-height: 107%; color: #000000; font-size: 11pt; mso-hansi-theme-font: minor-latin; mso-ansi-language: EN-US; font-family: 'Calibri',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-bidi-theme-font: minor-bidi;">I want to know how many personnel are decreased / increased base on 2017/01 or 2017/02 , .....</SPAN></P><P><SPAN style="mso-bidi-font-family: Arial; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; line-height: 107%; color: #000000; font-size: 11pt; mso-hansi-theme-font: minor-latin; mso-ansi-language: EN-US; font-family: 'Calibri',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-bidi-theme-font: minor-bidi;"> Regard</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Subtract-2-expression/m-p/1372314#M820552 apegahfar 2020-11-25T16:16:04Z Re: Subtract 2 expression https://community.qlik.com/t5/QlikView/Subtract-2-expression/m-p/1372315#M820553 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>Count({&lt;Date = {'2017-01','2017-02'}&gt;}[Personnel name])</STRONG></P></BODY></HTML> Wed, 09 Aug 2017 05:14:02 GMT https://community.qlik.com/t5/QlikView/Subtract-2-expression/m-p/1372315#M820553 Anil_Babu_Samineni 2017-08-09T05:14:02Z Re: Subtract 2 expression https://community.qlik.com/t5/QlikView/Subtract-2-expression/m-p/1372316#M820554 <HTML><HEAD></HEAD><BODY><P>May be like:</P><P><EM>=Count([Personnel name])-<STRONG>Above</STRONG>(Count([Personnel name]))</EM></P><P><EM><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172871_Capture.PNG" style="height: auto;" /><BR /></EM></P></BODY></HTML> Wed, 09 Aug 2017 05:18:47 GMT https://community.qlik.com/t5/QlikView/Subtract-2-expression/m-p/1372316#M820554 tresB 2017-08-09T05:18:47Z Re: Subtract 2 expression https://community.qlik.com/t5/QlikView/Subtract-2-expression/m-p/1372317#M820555 <HTML><HEAD></HEAD><BODY><P>Dear Tresesco</P><P>thank for your reply</P><P>it work well</P><P>regard</P></BODY></HTML> Wed, 09 Aug 2017 05:47:35 GMT https://community.qlik.com/t5/QlikView/Subtract-2-expression/m-p/1372317#M820555 apegahfar 2017-08-09T05:47:35Z