<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic swuehl, John, Miguel, Rob, Kaushik, Erich, Karl, Michael, Oleg in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/swuehl-John-Miguel-Rob-Kaushik-Erich-Karl-Michael-Oleg/m-p/357244#M132561</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt; Hi guys,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Please, help me to simplify an expression&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1-TDIST(fabs(Pract),N+after(N)-2,2) &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; N=Count({&amp;lt;&lt;A&gt;={'aaa'},&lt;B&gt;={'bbb'}&amp;gt;}&lt;C&gt;)&lt;/C&gt;&lt;/B&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Var=Sqr(Stdev({&amp;lt;&lt;A&gt;={'aaa'},&lt;B&gt;={'bbb'}&amp;gt;}&lt;C&gt;))&lt;/C&gt;&lt;/B&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Variable &lt;B&gt; has 'qqq', 'www', 'eee', 'rrr' tags.&lt;/B&gt;&lt;/P&gt;&lt;P&gt;I tried to change Pract to v1, N to v2, Var to v3.&lt;/P&gt;&lt;P&gt;In this case I have 8 new variables. I tried to replace &lt;B&gt; from v3 and v2 to in each expression. It didn't work.&lt;/B&gt;&lt;/P&gt;&lt;P&gt;Any thought how to do this?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks in advance,&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 17 May 2012 16:11:42 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2012-05-17T16:11:42Z</dc:date>
    <item>
      <title>swuehl, John, Miguel, Rob, Kaushik, Erich, Karl, Michael, Oleg</title>
      <link>https://community.qlik.com/t5/QlikView/swuehl-John-Miguel-Rob-Kaushik-Erich-Karl-Michael-Oleg/m-p/357244#M132561</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt; Hi guys,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Please, help me to simplify an expression&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1-TDIST(fabs(Pract),N+after(N)-2,2) &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; N=Count({&amp;lt;&lt;A&gt;={'aaa'},&lt;B&gt;={'bbb'}&amp;gt;}&lt;C&gt;)&lt;/C&gt;&lt;/B&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Var=Sqr(Stdev({&amp;lt;&lt;A&gt;={'aaa'},&lt;B&gt;={'bbb'}&amp;gt;}&lt;C&gt;))&lt;/C&gt;&lt;/B&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Variable &lt;B&gt; has 'qqq', 'www', 'eee', 'rrr' tags.&lt;/B&gt;&lt;/P&gt;&lt;P&gt;I tried to change Pract to v1, N to v2, Var to v3.&lt;/P&gt;&lt;P&gt;In this case I have 8 new variables. I tried to replace &lt;B&gt; from v3 and v2 to in each expression. It didn't work.&lt;/B&gt;&lt;/P&gt;&lt;P&gt;Any thought how to do this?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks in advance,&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 17 May 2012 16:11:42 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/swuehl-John-Miguel-Rob-Kaushik-Erich-Karl-Michael-Oleg/m-p/357244#M132561</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2012-05-17T16:11:42Z</dc:date>
    </item>
  </channel>
</rss>

