topic Help on Pivot Table in QlikView

Help on Pivot Table

panipat1990 — Wed, 23 Mar 2016 20:21:10 GMT

Hi Team,

i have one requirement which i have to show in pivot table. please help me on this.

for reference , i have attached screen shot for the same.

In that screen shot, Table-1 we have raw data. and on the right-hand side pivot table is our requirement and we need to achieve it on front-end side if possible.

In Pivot Table, Formula for Net_Realisation is = Sum(Net_Rev)-Sum(Selling Expense)

Please let me know if something else is needed.

Thanks

Gourav

Re: Help on Pivot Table

sunny_talwar — Wed, 23 Mar 2016 20:23:47 GMT

Would you be able to share the same data in a Excel file or qvw file?

Re: Help on Pivot Table

panipat1990 — Wed, 23 Mar 2016 20:38:15 GMT

Hi Sunny, when i click on "Reply to original discussion" option then i am not able to find the option for attach any document.

Would appreciate Please guide me where i can attach the same excel file for the above requirement,

Thanks

Gourav

Re: Help on Pivot Table

Chanty4u — Thu, 24 Mar 2016 08:31:35 GMT

U can open ur thread in new page.... it will look lik below.

top right on ur replay as "use advanced editor" select this down u will find attach