topic Get cell value from a pivot table using rowno() and columnno() - in chart expressions in QlikView https://community.qlik.com/t5/QlikView/Get-cell-value-from-a-pivot-table-using-rowno-and-columnno-in/m-p/776163#M275175 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table. I want to get the cell value of the pivot table using rowno() and columnno() in chart expression.</P><P>I am trying to get the totals from the pivot chart based on the rowno and column no.</P><P></P><P>Is this possible?</P><P></P><P>Thanks</P><P>Sarathi</P></BODY></HTML> Thu, 04 Dec 2014 12:50:45 GMT sarathi_pm 2014-12-04T12:50:45Z Get cell value from a pivot table using rowno() and columnno() - in chart expressions https://community.qlik.com/t5/QlikView/Get-cell-value-from-a-pivot-table-using-rowno-and-columnno-in/m-p/776163#M275175 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table. I want to get the cell value of the pivot table using rowno() and columnno() in chart expression.</P><P>I am trying to get the totals from the pivot chart based on the rowno and column no.</P><P></P><P>Is this possible?</P><P></P><P>Thanks</P><P>Sarathi</P></BODY></HTML> Thu, 04 Dec 2014 12:50:45 GMT https://community.qlik.com/t5/QlikView/Get-cell-value-from-a-pivot-table-using-rowno-and-columnno-in/m-p/776163#M275175 sarathi_pm 2014-12-04T12:50:45Z Re: Get cell value from a pivot table using rowno() and columnno() - in chart expressions https://community.qlik.com/t5/QlikView/Get-cell-value-from-a-pivot-table-using-rowno-and-columnno-in/m-p/776164#M275176 <HTML><HEAD></HEAD><BODY><P>No, that's not possible. If you want to show totals in the pivot table you can enable the Partial Sums option for the dimension on the Presentation tab. If you want to show the totals of the pivot table in another object you'll have to use the same expression you used in the pivot chart (and perhaps add some of the dimensions if you want the subtotals of dimensions).</P></BODY></HTML> Thu, 04 Dec 2014 14:38:47 GMT https://community.qlik.com/t5/QlikView/Get-cell-value-from-a-pivot-table-using-rowno-and-columnno-in/m-p/776164#M275176 Gysbert_Wassenaar 2014-12-04T14:38:47Z