Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

swuehl, John, Miguel, Rob, Kaushik, Erich, Karl, Michael, Oleg

Hi guys,

Please, help me to simplify an expression

1-TDIST(fabs(Pract),N+after(N)-2,2)

where Pract=([1st Time]-after([1st Time]))/SQRT(((N+after(N))/(N*after(N)))*(Var*(N-1)+after(Var)*(after(N)-1))/(N+after(N)-2))

         N=Count({<={'aaa'},={'bbb'}>})

         Var=Sqr(Stdev({<={'aaa'},={'bbb'}>}))

Variable has 'qqq', 'www', 'eee', 'rrr' tags.

I tried to change Pract to v1, N to v2, Var to v3.

In this case I have 8 new variables. I tried to replace from v3 and v2 to in each expression. It didn't work.

Any thought how to do this?

Thanks in advance,

Labels (1)
0 Replies