topic how to refer to a cell of itself in the p-table or textbox in QlikView https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900482#M313288 <HTML><HEAD></HEAD><BODY><P>when I try to define the backgroup-color with formula which base the cell's value</P><P>I have to re-write the formula of the value again into the backgroup-color formula box</P><P></P><P>but how can i refer to the cell of itself&nbsp; or get the value of it? just as I can use column(index) to refer to other column.</P><P></P><P></P><P>thanks</P></BODY></HTML> Fri, 24 Apr 2015 08:36:02 GMT guantujiang 2015-04-24T08:36:02Z how to refer to a cell of itself in the p-table or textbox https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900482#M313288 <HTML><HEAD></HEAD><BODY><P>when I try to define the backgroup-color with formula which base the cell's value</P><P>I have to re-write the formula of the value again into the backgroup-color formula box</P><P></P><P>but how can i refer to the cell of itself&nbsp; or get the value of it? just as I can use column(index) to refer to other column.</P><P></P><P></P><P>thanks</P></BODY></HTML> Fri, 24 Apr 2015 08:36:02 GMT https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900482#M313288 guantujiang 2015-04-24T08:36:02Z Re: how to refer to a cell of itself in the p-table or textbox https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900483#M313289 <HTML><HEAD></HEAD><BODY><P>You can't. You have to use the expression or the column index.</P></BODY></HTML> Fri, 24 Apr 2015 12:57:42 GMT https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900483#M313289 Gysbert_Wassenaar 2015-04-24T12:57:42Z Re: how to refer to a cell of itself in the p-table or textbox https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900484#M313290 <HTML><HEAD></HEAD><BODY><P>it sounds badly</P></BODY></HTML> Sat, 25 Apr 2015 02:14:07 GMT https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900484#M313290 guantujiang 2015-04-25T02:14:07Z Re: how to refer to a cell of itself in the p-table or textbox https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900485#M313291 <HTML><HEAD></HEAD><BODY><P>Qlikview is not a spreadsheet application. Perhaps you're using the wrong application.</P></BODY></HTML> Sat, 25 Apr 2015 07:24:05 GMT https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900485#M313291 Gysbert_Wassenaar 2015-04-25T07:24:05Z Re: how to refer to a cell of itself in the p-table or textbox https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900486#M313292 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you could define a variable containing your expression and use this variable in both your expression as well as your background color expression boxes.</P><P>This way you only have to define the expression once.</P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sat, 25 Apr 2015 07:43:35 GMT https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900486#M313292 MarcoWedel 2015-04-25T07:43:35Z Re: how to refer to a cell of itself in the p-table or textbox https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900487#M313293 <HTML><HEAD></HEAD><BODY><P>Just to add, I hope you are aware of Copy and Paste of the color expression using right click of your mouse.</P></BODY></HTML> Sat, 25 Apr 2015 08:25:11 GMT https://community.qlik.com/t5/QlikView/how-to-refer-to-a-cell-of-itself-in-the-p-table-or-textbox/m-p/900487#M313293 2015-04-25T08:25:11Z