Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shahinabi
Contributor
Contributor

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)