Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner - Creator
Partner - Creator

Var function from Tableau to Qlikview

Hi, this is driving me crazy   i've to find correspondant function of tableau variance i QV

I'm starting from this formula

dimHeader 2
AVar(COST)/var(VALUE)
BVar(COST)/var(VALUE)

Who can help me, pls?

1 Solution

Accepted Solutions
sunny_talwar

May be just square the Stdev function's result

(Stdev(COST)*Stdev(COST))/(Stdev(VALUE)*Stdev(VALUE))

View solution in original post

2 Replies
sunny_talwar

May be just square the Stdev function's result

(Stdev(COST)*Stdev(COST))/(Stdev(VALUE)*Stdev(VALUE))

vkish16161
Creator III
Creator III

Or simplifying Sunny's Formula:

Pow(Stdev(COST),2) / Pow(Stdev(VALUE),2)