topic Re: If-Else condition for table column in QlikView https://community.qlik.com/t5/QlikView/If-Else-condition-for-table-column/m-p/113414#M763674 <HTML><HEAD></HEAD><BODY><P>May be there are extra spaces or upper case/lower case issue... try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=If(Upper(Trim([Exchange])) = 'CROSS', DLY_CROSS_VAR_VAL, DLY_YTD_VAR_VAL)</STRONG></SPAN></P></BODY></HTML> Mon, 23 Jul 2018 15:13:34 GMT sunny_talwar 2018-07-23T15:13:34Z If-Else condition for table column https://community.qlik.com/t5/QlikView/If-Else-condition-for-table-column/m-p/113413#M763673 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can any one suggest on this issue. I have exchange field with values (YTD &amp; Cross). Now i have to display a column in normal table based on Exchange selection. If Exchange is YTD then 'DLY_YTD_VAR_VAL' field else 'DLY_CRSS_VAR_VAL' field.</P><P></P><P>I wrote below condition in expression of column but it is not working.</P><P></P><P>=if ([Exchange]='Cross',DLY_CROSS_VAR_VAL,DLY_YTD_VAR_VAL)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/If-Else-condition-for-table-column/m-p/113413#M763673 Anonymous 2020-11-25T16:16:04Z Re: If-Else condition for table column https://community.qlik.com/t5/QlikView/If-Else-condition-for-table-column/m-p/113414#M763674 <HTML><HEAD></HEAD><BODY><P>May be there are extra spaces or upper case/lower case issue... try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=If(Upper(Trim([Exchange])) = 'CROSS', DLY_CROSS_VAR_VAL, DLY_YTD_VAR_VAL)</STRONG></SPAN></P></BODY></HTML> Mon, 23 Jul 2018 15:13:34 GMT https://community.qlik.com/t5/QlikView/If-Else-condition-for-table-column/m-p/113414#M763674 sunny_talwar 2018-07-23T15:13:34Z