topic Re: Pivot table expersion in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-expersion/m-p/459592#M484706 <HTML><HEAD></HEAD><BODY><P>just use peek function in script and you can achieve it</P></BODY></HTML> Wed, 15 May 2013 05:26:22 GMT sujeetsingh 2013-05-15T05:26:22Z Pivot table expersion https://community.qlik.com/t5/QlikView/Pivot-table-expersion/m-p/459591#M484705 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA.Im trying to add and substarct amt1 in another expressions each row can anyone guide me how I can achieve this in best way thanks in advance</P></BODY></HTML> Wed, 15 May 2013 00:29:15 GMT https://community.qlik.com/t5/QlikView/Pivot-table-expersion/m-p/459591#M484705 srinivasa1 2013-05-15T00:29:15Z Re: Pivot table expersion https://community.qlik.com/t5/QlikView/Pivot-table-expersion/m-p/459592#M484706 <HTML><HEAD></HEAD><BODY><P>just use peek function in script and you can achieve it</P></BODY></HTML> Wed, 15 May 2013 05:26:22 GMT https://community.qlik.com/t5/QlikView/Pivot-table-expersion/m-p/459592#M484706 sujeetsingh 2013-05-15T05:26:22Z Re: Pivot table expersion https://community.qlik.com/t5/QlikView/Pivot-table-expersion/m-p/459593#M484707 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try This one</P><P></P><P>EX: RangeSum<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Amt1</SPAN><SPAN style="font-size: 8pt;">),0,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RowNo</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;">))) </SPAN></P><P></P></BODY></HTML> Wed, 15 May 2013 05:52:25 GMT https://community.qlik.com/t5/QlikView/Pivot-table-expersion/m-p/459593#M484707 kumarnatarajan 2013-05-15T05:52:25Z