Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner
Partner

exp+abs function in tableau

Hi, in Tableau i've this function:

exp(-3 * (abs(cost1) / 5 + abs(cost2) /8 ) / 1)


How can i translate in qlikview, pls....

Tks

Can

8 Replies
sunny_talwar

May be this

exp(-3 * (fabs(cost1)/5 + fabs(cost2)/8)/1)

canmarroig
Partner
Partner
Author

exp is not the same function...

in tableau

sum(exp(2)) = 467.941,533689

in qv

sum(exp(2)) = 7,3890560989307

sorry...more complicated

sunny_talwar

exp is not an exponential function?

sunny_talwar

Not sure how you got 467.941... but tableau's help say's that Exp(2) = 7.389... just like QV

All Functions (Categorical)

Capture.PNG

canmarroig
Partner
Partner
Author

I would like to know this..

sunny_talwar

Check my response below... exp() are the same function.

canmarroig
Partner
Partner
Author

sorry i deleted every other dimension, the result is not the same...

exp2.png

sunny_talwar

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