Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

If-Else condition for table column

Hi,

Can any one suggest on this issue. I have exchange field with values (YTD & 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.

I wrote below condition in expression of column but it is not working.

=if ([Exchange]='Cross',DLY_CROSS_VAR_VAL,DLY_YTD_VAR_VAL)

1 Reply
sunny_talwar

May be there are extra spaces or upper case/lower case issue... try this

=If(Upper(Trim([Exchange])) = 'CROSS', DLY_CROSS_VAR_VAL, DLY_YTD_VAR_VAL)