topic Re: Straight Table with Variances in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-with-Variances/m-p/907290#M469175 <HTML><HEAD></HEAD><BODY><P>Please find the attached</P></BODY></HTML> Tue, 21 Jul 2015 06:04:45 GMT Kushal_Chawda 2015-07-21T06:04:45Z Straight Table with Variances https://community.qlik.com/t5/QlikView/Straight-Table-with-Variances/m-p/907287#M469172 <HTML><HEAD></HEAD><BODY><P>Hi There </P><P></P><P>I would like to create a Table with a variance between the previous day and the Current day.</P><P>What could I use in the set analysis to achieve this variance and variance Percentage?</P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 285px;"><TBODY><TR><TD height="20" style="text-align: center;" width="64">Date </TD><TD style="text-align: center;" width="93">Sales Amount</TD><TD style="text-align: center;" width="64">Variance</TD><TD style="text-align: center;" width="64">Variance%</TD></TR><TR><TD align="right" height="20" style="text-align: center;">20150701</TD><TD align="right" style="text-align: center;">10000</TD><TD align="right" style="text-align: center;">0</TD><TD align="right" class="xl63" style="text-align: center;">0%</TD></TR><TR><TD align="right" height="20" style="text-align: center;">20150702</TD><TD align="right" style="text-align: center;">12000</TD><TD align="right" style="text-align: center;">2000</TD><TD align="right" class="xl63" style="text-align: center;">20%</TD></TR><TR><TD align="right" height="20" style="text-align: center;">20150703</TD><TD align="right" style="text-align: center;">9000</TD><TD align="right" style="text-align: center;">-3000</TD><TD align="right" class="xl63" style="text-align: center;">-25%</TD></TR><TR><TD align="right" height="20" style="text-align: center;">20150704</TD><TD align="right" style="text-align: center;">5000</TD><TD align="right" style="text-align: center;">-4000</TD><TD align="right" class="xl63" style="text-align: center;">-44%</TD></TR><TR><TD align="right" height="20" style="text-align: center;">20150705</TD><TD align="right" style="text-align: center;">15000</TD><TD align="right" style="text-align: center;">10000</TD><TD align="right" class="xl63" style="text-align: center;">200%</TD></TR><TR><TD align="right" height="20" style="text-align: center;">20150706</TD><TD align="right" style="text-align: center;">3000</TD><TD align="right" style="text-align: center;">-12000</TD><TD align="right" class="xl63" style="text-align: center;">-80%</TD></TR><TR><TD align="right" height="20" style="text-align: center;">20150707</TD><TD align="right" style="text-align: center;">18000</TD><TD align="right" style="text-align: center;">15000</TD><TD align="right" class="xl63" style="text-align: center;">500%</TD></TR></TBODY></TABLE><P></P><P></P><P>Thank you</P></BODY></HTML> Tue, 21 Jul 2015 05:43:37 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-Variances/m-p/907287#M469172 rido1421 2015-07-21T05:43:37Z Re: Straight Table with Variances https://community.qlik.com/t5/QlikView/Straight-Table-with-Variances/m-p/907288#M469173 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Tue, 21 Jul 2015 05:54:06 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-Variances/m-p/907288#M469173 tresB 2015-07-21T05:54:06Z Re: Straight Table with Variances https://community.qlik.com/t5/QlikView/Straight-Table-with-Variances/m-p/907289#M469174 <HTML><HEAD></HEAD><BODY><P>WOW! Thanks </P></BODY></HTML> Tue, 21 Jul 2015 06:04:18 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-Variances/m-p/907289#M469174 rido1421 2015-07-21T06:04:18Z Re: Straight Table with Variances https://community.qlik.com/t5/QlikView/Straight-Table-with-Variances/m-p/907290#M469175 <HTML><HEAD></HEAD><BODY><P>Please find the attached</P></BODY></HTML> Tue, 21 Jul 2015 06:04:45 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-Variances/m-p/907290#M469175 Kushal_Chawda 2015-07-21T06:04:45Z Re: Straight Table with Variances https://community.qlik.com/t5/QlikView/Straight-Table-with-Variances/m-p/907291#M469176 <HTML><HEAD></HEAD><BODY><P>1.Expression 1 = sum[(Sales Amount])</P><P>2. expression 2 =sum([Sales Amount])- Above([Sales Amount],1)</P><P>3. Expression 3 = = (sum([Sales Amount])-Above([Sales Amount]))/Above([Sales Amount])</P><P>PFA</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>Regards </P><P>Ankit Bisht</P></BODY></HTML> Tue, 21 Jul 2015 06:50:43 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-Variances/m-p/907291#M469176 ankitbisht01 2015-07-21T06:50:43Z