topic Re: Question on Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569401#M212210 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You should be able to use Before(...) or Before(TOTAL ...) to get the previous closing total, but you will have to create a single expression that returns same values as the total line. If you are not sure how to do that, I suggest you post a sample qvw so that it can be looked at in more detail.</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Wed, 26 Feb 2014 07:02:59 GMT jonathandienst 2014-02-26T07:02:59Z Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569399#M212208 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P></P><P>I have a question regarding pivot table. I have a table that looks like this:</P><P></P><P><IMG alt="table.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/53825_table.PNG.png" style="width: 620px; height: 117px;" /></P><P></P><P>Now the totals : 1000, 140 and 700 (background is red) should be in the Beginning balance value under the Month Feb-2014</P><P></P><P>So, I have an excel file which contains only the beginning balance for Jan-2014, The total that is generated from Jan-2014 or the Ending balance should be placed on the Beginning Balance of Feb-2014 and so on. (For example, Feb-2014 ending balance will now go to Mar-2014 beginning balance)</P><P></P><P>How do I achieve this? Is it possible on Pivot table?</P><P></P><P></P><P>Thanks in advance,</P><P>Donna</P></BODY></HTML> Wed, 26 Feb 2014 01:44:59 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569399#M212208 2014-02-26T01:44:59Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569400#M212209 <HTML><HEAD></HEAD><BODY><P>bump</P></BODY></HTML> Wed, 26 Feb 2014 05:25:43 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569400#M212209 2014-02-26T05:25:43Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569401#M212210 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You should be able to use Before(...) or Before(TOTAL ...) to get the previous closing total, but you will have to create a single expression that returns same values as the total line. If you are not sure how to do that, I suggest you post a sample qvw so that it can be looked at in more detail.</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Wed, 26 Feb 2014 07:02:59 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569401#M212210 jonathandienst 2014-02-26T07:02:59Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569402#M212211 <HTML><HEAD></HEAD><BODY><P>I'll try to provide you with a dummy data. But If you do have a sample qvd that can give me the initial idea how to do it. It will be very helpful.</P></BODY></HTML> Wed, 26 Feb 2014 07:15:35 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569402#M212211 2014-02-26T07:15:35Z Re: Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569403#M212212 <HTML><HEAD></HEAD><BODY><P>Please see attached file!</P></BODY></HTML> Wed, 26 Feb 2014 07:29:04 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569403#M212212 2014-02-26T07:29:04Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569404#M212213 <HTML><HEAD></HEAD><BODY><P>bump!</P></BODY></HTML> Thu, 27 Feb 2014 01:01:27 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569404#M212213 2014-02-27T01:01:27Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569405#M212214 <HTML><HEAD></HEAD><BODY><P>bump!</P></BODY></HTML> Thu, 27 Feb 2014 08:00:49 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569405#M212214 2014-02-27T08:00:49Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569406#M212215 <HTML><HEAD></HEAD><BODY><P>bump again!</P></BODY></HTML> Fri, 28 Feb 2014 00:08:04 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569406#M212215 2014-02-28T00:08:04Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569407#M212216 <HTML><HEAD></HEAD><BODY><P>I had a look at your sample. On reflection it would be better to do this in script. I have not got time at the moment to assist in more detail, but I would add a resident load to load the previous periods closing balance into the AMOUNT field. Then your pivot will work properly.</P><P></P><P>Sorry I cannot spend more time on this right now. Perhaps someone else can pick this up.</P><P>Jonathan</P></BODY></HTML> Fri, 28 Feb 2014 12:01:11 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569407#M212216 jonathandienst 2014-02-28T12:01:11Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569408#M212217 <HTML><HEAD></HEAD><BODY><P>Alright! Thanks for you help Jonathan.</P><P></P><P>BUMP!</P></BODY></HTML> Sat, 01 Mar 2014 16:32:22 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569408#M212217 2014-03-01T16:32:22Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569409#M212218 <HTML><HEAD></HEAD><BODY><P>bump!</P></BODY></HTML> Mon, 03 Mar 2014 05:52:58 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569409#M212218 2014-03-03T05:52:58Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569410#M212219 <HTML><HEAD></HEAD><BODY><P>bump!</P></BODY></HTML> Wed, 05 Mar 2014 04:10:02 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569410#M212219 2014-03-05T04:10:02Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569411#M212220 <HTML><HEAD></HEAD><BODY><P>^bump</P></BODY></HTML> Wed, 12 Mar 2014 07:42:44 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569411#M212220 2014-03-12T07:42:44Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569412#M212221 <HTML><HEAD></HEAD><BODY><P>Donna</P><P></P><P>Can you upload your sample_source.xlsx file to test mods to the load script?</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Fri, 14 Mar 2014 06:09:10 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569412#M212221 jonathandienst 2014-03-14T06:09:10Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569413#M212222 <HTML><HEAD></HEAD><BODY><P>Hi Donna, something like this?</P><P><IMG alt="2014-03-14_0725.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/55023_2014-03-14_0725.png" style="width: 620px; height: 210px;" /></P></BODY></HTML> Fri, 14 Mar 2014 06:27:17 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569413#M212222 stabben23 2014-03-14T06:27:17Z Re: Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569414#M212223 <HTML><HEAD></HEAD><BODY><P>Hi ! Please see attached.</P></BODY></HTML> Fri, 14 Mar 2014 06:32:07 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569414#M212223 2014-03-14T06:32:07Z Re: Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569415#M212224 <HTML><HEAD></HEAD><BODY><P>Hi! Please see attached. </P></BODY></HTML> Fri, 14 Mar 2014 06:32:50 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569415#M212224 2014-03-14T06:32:50Z Re: Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569416#M212225 <HTML><HEAD></HEAD><BODY><P>I'm sorry can you explain it a bit further? Thanks!</P></BODY></HTML> Fri, 14 Mar 2014 06:34:54 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569416#M212225 2014-03-14T06:34:54Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569417#M212226 <HTML><HEAD></HEAD><BODY><P>up</P></BODY></HTML> Wed, 02 Apr 2014 08:33:27 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569417#M212226 2014-04-02T08:33:27Z Re: Question on Pivot Table https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569418#M212227 <HTML><HEAD></HEAD><BODY><P>bump</P></BODY></HTML> Thu, 03 Apr 2014 01:30:42 GMT https://community.qlik.com/t5/QlikView/Question-on-Pivot-Table/m-p/569418#M212227 2014-04-03T01:30:42Z