topic after function not working in QlikView https://community.qlik.com/t5/QlikView/after-function-not-working/m-p/405807#M566030 <HTML><HEAD></HEAD><BODY><P>hi.</P><P>i would like to do the following in cross tab</P><TABLE border="0" cellpadding="0" cellspacing="0" width="564"><TBODY><TR><TD class="xl63" height="20" width="180">Product</TD><TD class="xl63" style="border-left: medium none;" width="64">sales1</TD><TD class="xl63" style="border-left: medium none;" width="64">sales2</TD><TD class="xl63" style="border-left: medium none;" width="64">sales3</TD><TD class="xl63" style="border-left: medium none;" width="64">sale4</TD><TD class="xl63" style="border-left: medium none;" width="64">sale5</TD><TD class="xl63" style="border-left: medium none;" width="64">sale6</TD></TR><TR><TD class="xl63" height="20" style="border-top: medium none;"> </TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">100</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">200</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">350</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">120</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">200</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">500</TD></TR><TR><TD class="xl63" height="20" style="border-top: medium none;"> </TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">400</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">100</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">450</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">210</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">300</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">100</TD></TR><TR><TD class="xl63" height="20" style="border-top: medium none;"> </TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">500</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">300</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">150</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">321</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">400</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">100</TD></TR><TR><TD class="xl63" height="68" style="border-top: medium none;">total</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1000</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">600</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">950</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">651</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">900</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;"> </TD></TR><TR><TD class="xl64" height="20" style="border-top: medium none;">totsales for next 3 months</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;"> </TD><TD class="xl63" style="border-left: medium none; border-top: medium none;"> </TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">670</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">820</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;"> </TD><TD class="xl63" style="border-left: medium none; border-top: medium none;"> </TD></TR></TBODY></TABLE><P></P><P>totalsales for next 3 months = current total sales+total sales of next two columns.</P><P>I used after of function and it didnt work. can anyone help?</P><P></P><P>Regards.</P><P>siva</P></BODY></HTML> Wed, 09 Jan 2013 06:05:47 GMT Siva_Sankar 2013-01-09T06:05:47Z after function not working https://community.qlik.com/t5/QlikView/after-function-not-working/m-p/405807#M566030 <HTML><HEAD></HEAD><BODY><P>hi.</P><P>i would like to do the following in cross tab</P><TABLE border="0" cellpadding="0" cellspacing="0" width="564"><TBODY><TR><TD class="xl63" height="20" width="180">Product</TD><TD class="xl63" style="border-left: medium none;" width="64">sales1</TD><TD class="xl63" style="border-left: medium none;" width="64">sales2</TD><TD class="xl63" style="border-left: medium none;" width="64">sales3</TD><TD class="xl63" style="border-left: medium none;" width="64">sale4</TD><TD class="xl63" style="border-left: medium none;" width="64">sale5</TD><TD class="xl63" style="border-left: medium none;" width="64">sale6</TD></TR><TR><TD class="xl63" height="20" style="border-top: medium none;"> </TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">100</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">200</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">350</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">120</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">200</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">500</TD></TR><TR><TD class="xl63" height="20" style="border-top: medium none;"> </TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">400</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">100</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">450</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">210</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">300</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">100</TD></TR><TR><TD class="xl63" height="20" style="border-top: medium none;"> </TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">500</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">300</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">150</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">321</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">400</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">100</TD></TR><TR><TD class="xl63" height="68" style="border-top: medium none;">total</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1000</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">600</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">950</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">651</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">900</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;"> </TD></TR><TR><TD class="xl64" height="20" style="border-top: medium none;">totsales for next 3 months</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;"> </TD><TD class="xl63" style="border-left: medium none; border-top: medium none;"> </TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">670</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">820</TD><TD class="xl63" style="border-left: medium none; border-top: medium none;"> </TD><TD class="xl63" style="border-left: medium none; border-top: medium none;"> </TD></TR></TBODY></TABLE><P></P><P>totalsales for next 3 months = current total sales+total sales of next two columns.</P><P>I used after of function and it didnt work. can anyone help?</P><P></P><P>Regards.</P><P>siva</P></BODY></HTML> Wed, 09 Jan 2013 06:05:47 GMT https://community.qlik.com/t5/QlikView/after-function-not-working/m-p/405807#M566030 Siva_Sankar 2013-01-09T06:05:47Z Re: after function not working https://community.qlik.com/t5/QlikView/after-function-not-working/m-p/405808#M566031 <HTML><HEAD></HEAD><BODY><P>After function will work only on pivot table not for stright table.</P></BODY></HTML> Wed, 09 Jan 2013 06:08:52 GMT https://community.qlik.com/t5/QlikView/after-function-not-working/m-p/405808#M566031 khadeer 2013-01-09T06:08:52Z Re: after function not working https://community.qlik.com/t5/QlikView/after-function-not-working/m-p/405809#M566032 <HTML><HEAD></HEAD><BODY><P>Yes, can you please let me know how to achieve this on pivot table.</P></BODY></HTML> Wed, 09 Jan 2013 06:31:22 GMT https://community.qlik.com/t5/QlikView/after-function-not-working/m-p/405809#M566032 Siva_Sankar 2013-01-09T06:31:22Z Re: after function not working https://community.qlik.com/t5/QlikView/after-function-not-working/m-p/405810#M566033 <HTML><HEAD></HEAD><BODY><P>I hope accumaltion resolve ur prblm.</P></BODY></HTML> Wed, 09 Jan 2013 07:02:30 GMT https://community.qlik.com/t5/QlikView/after-function-not-working/m-p/405810#M566033 khadeer 2013-01-09T07:02:30Z