Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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,

0 Replies