topic Re: question on displaying a pivot cell value in a text box in QlikView https://community.qlik.com/t5/QlikView/question-on-displaying-a-pivot-cell-value-in-a-text-box/m-p/762235#M271040 <HTML><HEAD></HEAD><BODY><P>Unfortunately, there is no way you can address a cell in a pivot table to retrieve its value (at least not that I'm aware of). But, if you know the dimension values in question, you could use them in a set analysis expression to "address the cell". Let's assume the pivot table has the dimensions Client and Year, and the expression Sum(Sales). And you want the cell for ClientA and year 2013. In your text box, you would use this expression:</P><P></P><P>Sum({$&lt;Client = {'ClienteA'}, Year = {2013}&gt;} Sales)</P><P></P><P>Hope it helps.</P><P></P><P>Cheers,</P><P></P><P> - Bruno.</P></BODY></HTML> Wed, 03 Dec 2014 02:01:16 GMT Anonymous 2014-12-03T02:01:16Z question on displaying a pivot cell value in a text box https://community.qlik.com/t5/QlikView/question-on-displaying-a-pivot-cell-value-in-a-text-box/m-p/762234#M271039 <HTML><HEAD></HEAD><BODY><P>Is there a simple way to get the value of a cell in a pivot chart to display in a text box ?</P><P></P><P>Gerry</P></BODY></HTML> Tue, 02 Dec 2014 22:59:59 GMT https://community.qlik.com/t5/QlikView/question-on-displaying-a-pivot-cell-value-in-a-text-box/m-p/762234#M271039 gerrycastellino 2014-12-02T22:59:59Z Re: question on displaying a pivot cell value in a text box https://community.qlik.com/t5/QlikView/question-on-displaying-a-pivot-cell-value-in-a-text-box/m-p/762235#M271040 <HTML><HEAD></HEAD><BODY><P>Unfortunately, there is no way you can address a cell in a pivot table to retrieve its value (at least not that I'm aware of). But, if you know the dimension values in question, you could use them in a set analysis expression to "address the cell". Let's assume the pivot table has the dimensions Client and Year, and the expression Sum(Sales). And you want the cell for ClientA and year 2013. In your text box, you would use this expression:</P><P></P><P>Sum({$&lt;Client = {'ClienteA'}, Year = {2013}&gt;} Sales)</P><P></P><P>Hope it helps.</P><P></P><P>Cheers,</P><P></P><P> - Bruno.</P></BODY></HTML> Wed, 03 Dec 2014 02:01:16 GMT https://community.qlik.com/t5/QlikView/question-on-displaying-a-pivot-cell-value-in-a-text-box/m-p/762235#M271040 Anonymous 2014-12-03T02:01:16Z