Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New 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



1 Reply

Re: Raname data value

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