topic Re: calculated! in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/calculated/m-p/1067222#M9015 <HTML><HEAD></HEAD><BODY><P>Can you reply with some screen shots and a few more details of what you are trying to accomplish?</P><P><BR /> </P></BODY></HTML> Thu, 31 Mar 2016 14:42:34 GMT Anonymous 2016-03-31T14:42:34Z calculated! https://community.qlik.com/t5/Qlik-NPrinting/calculated/m-p/1067220#M9013 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In Nprinting I have a pivot excel template which has few columns like below</P><P></P><P>Amount&nbsp; ¦ Input ¦ Month&nbsp; -- these are source . Once the input gets as a source for ex</P><P></P><P>Input</P><P>+Vendors&nbsp; +Customer -if you expand vendors or customers we can see each month </P><P></P><P>now i need to add vendors + Customers as calculated field..</P><P></P><P>the problem is vendors and Customers are output from input column of the source</P><P></P><P>any sugge..</P></BODY></HTML> Thu, 24 Mar 2016 13:06:40 GMT https://community.qlik.com/t5/Qlik-NPrinting/calculated/m-p/1067220#M9013 raadwiptec 2016-03-24T13:06:40Z Re: calculated! https://community.qlik.com/t5/Qlik-NPrinting/calculated/m-p/1067221#M9014 <HTML><HEAD></HEAD><BODY><P>any suggestions here</P></BODY></HTML> Thu, 24 Mar 2016 15:58:21 GMT https://community.qlik.com/t5/Qlik-NPrinting/calculated/m-p/1067221#M9014 raadwiptec 2016-03-24T15:58:21Z Re: calculated! https://community.qlik.com/t5/Qlik-NPrinting/calculated/m-p/1067222#M9015 <HTML><HEAD></HEAD><BODY><P>Can you reply with some screen shots and a few more details of what you are trying to accomplish?</P><P><BR /> </P></BODY></HTML> Thu, 31 Mar 2016 14:42:34 GMT https://community.qlik.com/t5/Qlik-NPrinting/calculated/m-p/1067222#M9015 Anonymous 2016-03-31T14:42:34Z Re: calculated! https://community.qlik.com/t5/Qlik-NPrinting/calculated/m-p/1067223#M9016 <HTML><HEAD></HEAD><BODY><P>You can pass parameters and filters in NPrinting based on what's in your QVW, but I can't see what you're trying to do. </P></BODY></HTML> Thu, 31 Mar 2016 14:50:33 GMT https://community.qlik.com/t5/Qlik-NPrinting/calculated/m-p/1067223#M9016 ThornOfCrowns 2016-03-31T14:50:33Z Re: calculated! https://community.qlik.com/t5/Qlik-NPrinting/calculated/m-p/1067224#M9017 <HTML><HEAD></HEAD><BODY><P>hi james</P><P></P><P>Based on a QVW chart.i have prepared a pivot table in nprinting report. in the pivot table their are 3 columns</P><P></P><P>input column - values are vendors and customers- so when we run the nprinting report the report looks as below- this is collapsed version</P><P></P><P>sum Amount&nbsp;&nbsp;&nbsp;&nbsp; ¦ input&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ¦ Month</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +Vendors&nbsp; + Customers&nbsp;&nbsp; </P><P></P><P>expanded version</P><P style="font-size: 13.3333px;">sum Amount&nbsp;&nbsp;&nbsp;&nbsp; ¦ input&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ¦ Month</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +Vendors&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + Customers&nbsp;&nbsp; </P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01 ¦ 02 ¦ 03 ...12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> 01 ¦ 02 ¦ 03 ...12</SPAN></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.5¦ 100¦ 150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200¦ 240¦ 234 ....</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">now i need to add an&nbsp; additional calculated column&nbsp; in pivot table&nbsp;&nbsp;&nbsp; 'difference' which is vendors - customers in the pivot chart of nprinting. We can make the difference directly in qvw but iam checking whether their is an option in nprinting itself.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">sum Amount&nbsp;&nbsp;&nbsp;&nbsp; ¦ input&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ¦ Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ¦ difference</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +Vendors&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + Customers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01 ¦ 02 ¦ 03 ...12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> 01 ¦ 02 ¦ 03 ...12</SPAN></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.5¦ 100¦ 150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200¦ 240¦ 234 ....</P></BODY></HTML> Fri, 01 Apr 2016 06:40:54 GMT https://community.qlik.com/t5/Qlik-NPrinting/calculated/m-p/1067224#M9017 raadwiptec 2016-04-01T06:40:54Z