topic Re: Qlikview Chat Expression in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Chat-Expression/m-p/1416632#M811851 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Yes, Same I implemented. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Thank You.</P><P></P><P>Best Regards,</P><P>Hari</P></BODY></HTML> Mon, 09 Oct 2017 12:30:18 GMT dunnalahk123 2017-10-09T12:30:18Z Qlikview Chat Expression https://community.qlik.com/t5/QlikView/Qlikview-Chat-Expression/m-p/1416630#M811849 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can some one help me</P><P></P><P>I have a one Qlikview Chart Expression in that I am writing below expression&nbsp; but sum is not working for Total FTE at horizontal level.</P><P></P><P>=Sum(Aggr(((SUM([ASM_SSH_Hours])+SUM([ASM_RCSH_Hours])+ (SUM(AGGR([Total Service Credit Balance in Hours],[Project ID]))*0.35)) * (Avg([FTE Multiplier]))), Global, Region, Subregion, Subregion1, PSA_POCOUNTRY))</P><P></P><P>Example:</P><P></P><P>Region&nbsp; ASMFTE&nbsp; TAMFTE&nbsp;&nbsp;&nbsp;&nbsp; TotalFTE</P><P>WW&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; it should give me 900 but it's not working.</P><P></P><P>Region&nbsp; ASMFTE&nbsp; TAMFTE&nbsp;&nbsp;&nbsp;&nbsp; TotalFTE</P><P>AMS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; it should give me 900 but it's not working.</P><P>APJ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; it should give me 500 but its not working</P><P>EMEA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; it should give me 200 but its not working</P><P></P><P></P><P>it works at vertical level(column level)</P><P></P><P></P><P>Region&nbsp; ASMFTE&nbsp; TAMFTE&nbsp;&nbsp;&nbsp;&nbsp; TotalFTE</P><P>AMS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; it should give me 900 but it's not working.</P><P>APJ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; it should give me 500 but its not working</P><P>EMEA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; it should give me 200 but its not working</P><P><SPAN style="color: #00ff00;"><STRONG>Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 700&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vertical its working correctly-----------no problem at vertical sum.</STRONG></SPAN></P><P></P><P>attaching QVW For Your Reference.</P><P></P><P>Please advise.</P><P></P><P>Best Regards,</P><P>HK</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Qlikview-Chat-Expression/m-p/1416630#M811849 dunnalahk123 2020-11-25T16:16:04Z Re: Qlikview Chat Expression https://community.qlik.com/t5/QlikView/Qlikview-Chat-Expression/m-p/1416631#M811850 <HTML><HEAD></HEAD><BODY><P>May be try this for Total FTE</P><P></P><P><STRONG>Column(1) + </STRONG></P><P><STRONG>Column(2) + </STRONG></P><P><STRONG>Column(3) + </STRONG></P><P><STRONG>Column(4) + </STRONG></P><P><STRONG>Column(5) + </STRONG></P><P><STRONG>Column(6)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179030_Capture.PNG" style="height: 72px; width: 620px;" /></P></BODY></HTML> Mon, 09 Oct 2017 12:22:24 GMT https://community.qlik.com/t5/QlikView/Qlikview-Chat-Expression/m-p/1416631#M811850 sunny_talwar 2017-10-09T12:22:24Z Re: Qlikview Chat Expression https://community.qlik.com/t5/QlikView/Qlikview-Chat-Expression/m-p/1416632#M811851 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Yes, Same I implemented. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Thank You.</P><P></P><P>Best Regards,</P><P>Hari</P></BODY></HTML> Mon, 09 Oct 2017 12:30:18 GMT https://community.qlik.com/t5/QlikView/Qlikview-Chat-Expression/m-p/1416632#M811851 dunnalahk123 2017-10-09T12:30:18Z