topic Re: exp+abs function in tableau in QlikView https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48861#M458103 <HTML><HEAD></HEAD><BODY><P>Check my response below... exp() are the same function.</P></BODY></HTML> Thu, 17 May 2018 13:22:37 GMT sunny_talwar 2018-05-17T13:22:37Z exp+abs function in tableau https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48855#M458097 <HTML><HEAD></HEAD><BODY><P>Hi, in Tableau i've this function:</P><P></P><P><EM>exp(-3 * (<SPAN style="font-size: 10pt;">abs(cost1) / 5 + </SPAN><SPAN style="font-size: 10pt;">abs(cost2) /8 </SPAN><SPAN style="font-size: 10pt;">) / 1</SPAN></EM><SPAN style="font-size: 10pt;"><EM>)</EM></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">How can i translate in qlikview, pls....</SPAN></P><P><SPAN style="font-size: 10pt;">Tks</SPAN></P><P><SPAN style="font-size: 10pt;">Can<BR /></SPAN></P></BODY></HTML> Thu, 17 May 2018 12:58:27 GMT https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48855#M458097 canmarroig 2018-05-17T12:58:27Z Re: exp+abs function in tableau https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48856#M458098 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>exp(-3 * (fabs(cost1)/5 + fabs(cost2)/8)/1)</P></BODY></HTML> Thu, 17 May 2018 13:00:49 GMT https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48856#M458098 sunny_talwar 2018-05-17T13:00:49Z Re: exp+abs function in tableau https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48857#M458099 <HTML><HEAD></HEAD><BODY><P>exp is not the same function...</P><P>in tableau</P><P>sum(exp(2)) = <SPAN style="font-size: 13.3333px;">467.941,533689</SPAN></P><P>in qv</P><P>sum(exp(2)) = 7,3890560989307</P><P>sorry...more complicated <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Thu, 17 May 2018 13:13:19 GMT https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48857#M458099 canmarroig 2018-05-17T13:13:19Z Re: exp+abs function in tableau https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48858#M458100 <HTML><HEAD></HEAD><BODY><P>exp is not an exponential function?</P></BODY></HTML> Thu, 17 May 2018 13:15:59 GMT https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48858#M458100 sunny_talwar 2018-05-17T13:15:59Z Re: exp+abs function in tableau https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48859#M458101 <HTML><HEAD></HEAD><BODY><P>Not sure how you got 467.941... but tableau's help say's that Exp(2) = 7.389... just like QV <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P><A href="https://onlinehelp.tableau.com/current/pro/desktop/en-us/functions_all_categories.html" title="https://onlinehelp.tableau.com/current/pro/desktop/en-us/functions_all_categories.html">All Functions (Categorical)</A></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/202677_Capture.PNG" style="height: 540px; width: 620px;" /></P></BODY></HTML> Thu, 17 May 2018 13:21:24 GMT https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48859#M458101 sunny_talwar 2018-05-17T13:21:24Z Re: exp+abs function in tableau https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48860#M458102 <HTML><HEAD></HEAD><BODY><P>I would like to know this..</P></BODY></HTML> Thu, 17 May 2018 13:21:47 GMT https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48860#M458102 canmarroig 2018-05-17T13:21:47Z Re: exp+abs function in tableau https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48861#M458103 <HTML><HEAD></HEAD><BODY><P>Check my response below... exp() are the same function.</P></BODY></HTML> Thu, 17 May 2018 13:22:37 GMT https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48861#M458103 sunny_talwar 2018-05-17T13:22:37Z Re: exp+abs function in tableau https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48862#M458104 <HTML><HEAD></HEAD><BODY><P>sorry i deleted every other dimension, the result is not the same...</P><P><IMG alt="exp2.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/202666_exp2.png" style="height: 340px; width: 620px;" /></P></BODY></HTML> Thu, 17 May 2018 13:33:50 GMT https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48862#M458104 canmarroig 2018-05-17T13:33:50Z Re: exp+abs function in tableau https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48863#M458105 <HTML><HEAD></HEAD><BODY><P>I cannot comment anything related to Tableau as I have never used it... but the help says that the Exp(2) = 7.389... may be remove the Sum() to see it's true value in Tableau <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 17 May 2018 13:35:50 GMT https://community.qlik.com/t5/QlikView/exp-abs-function-in-tableau/m-p/48863#M458105 sunny_talwar 2018-05-17T13:35:50Z