Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Raname data value

Hi, I have a set of data, Column A Consist of Fleet name and Column B Consist of Registration Number of the Fleet. Some of the registration are not recorded.

I want to say that if there is no record in column B take the name in column A.

Reason for wanting to use column b is that as these are official fleet registration they are more accurate than fleet names which sometimes can have duplicates

 

Thanks

1 Reply
Highlighted
Partner
Partner

Re: Raname data value

if(IsNull(Column B),Column A, Column B)