https://community.qlik.com/t5/QlikView/How-to-create-formula-in-variable-field-for-button/m-p/1860807#M1216131 <P>HI&nbsp;</P> <P>Try like below</P> <P>=if(vCurr = 1, '[Product Category]', '[Product Sub-Category]')</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MayilVahanan_0-1637221721619.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66912iB3251D6E575AB947/image-size/medium?v=v2&amp;px=400" role="button" title="MayilVahanan_0-1637221721619.png" alt="MayilVahanan_0-1637221721619.png" /></span></P> <P>&nbsp;</P> <P>Use the vFieldName variable where its required like below</P> <P>$(vFieldName)</P> Thu, 18 Nov 2021 07:49:24 GMT MayilVahanan 2021-11-18T07:49:24Z https://community.qlik.com/t5/QlikView/How-to-create-formula-in-variable-field-for-button/m-p/1860598#M1216118 <P>Hi,</P> <P>&nbsp;</P> <P>Is there any way to construct a formula in the variable field for button? I found it doesnt work. My purpose is very simple. If the variable (vCurr=1), then i use the column&nbsp; [Product Category] to get, otherwise i use Product Sub-Category to get value.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tonytang_0-1637168695966.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66873i453A07630FD937EE/image-size/medium?v=v2&amp;px=400" role="button" title="tonytang_0-1637168695966.png" alt="tonytang_0-1637168695966.png" /></span></P> <P>&nbsp;</P> <P>But, the function does not work. Is there any way to achieve the effect?</P> <P>Thanks</P> <P>&nbsp;</P> Wed, 17 Nov 2021 17:04:42 GMT https://community.qlik.com/t5/QlikView/How-to-create-formula-in-variable-field-for-button/m-p/1860598#M1216118 tonytang 2021-11-17T17:04:42Z https://community.qlik.com/t5/QlikView/How-to-create-formula-in-variable-field-for-button/m-p/1860807#M1216131 <P>HI&nbsp;</P> <P>Try like below</P> <P>=if(vCurr = 1, '[Product Category]', '[Product Sub-Category]')</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MayilVahanan_0-1637221721619.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66912iB3251D6E575AB947/image-size/medium?v=v2&amp;px=400" role="button" title="MayilVahanan_0-1637221721619.png" alt="MayilVahanan_0-1637221721619.png" /></span></P> <P>&nbsp;</P> <P>Use the vFieldName variable where its required like below</P> <P>$(vFieldName)</P> Thu, 18 Nov 2021 07:49:24 GMT https://community.qlik.com/t5/QlikView/How-to-create-formula-in-variable-field-for-button/m-p/1860807#M1216131 MayilVahanan 2021-11-18T07:49:24Z https://community.qlik.com/t5/QlikView/How-to-create-formula-in-variable-field-for-button/m-p/1861770#M1216165 <P>it works. Thx</P> Sun, 21 Nov 2021 08:53:59 GMT https://community.qlik.com/t5/QlikView/How-to-create-formula-in-variable-field-for-button/m-p/1861770#M1216165 tonytang 2021-11-21T08:53:59Z