Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
robin_heijt
Contributor

Fill expression IF left blank

Hi,

I have a table in my app that includes data from several data sources.

All of these data sources are connected by an ID assigned to every person.

But in order to show a persons name with their ID in a table, I would have to add in 4 different columns from 4 different sources to show the names.

I would like to see 1 column for the ID and 1 for the name, so I am wondering if it is possible to write an expression that allows for the name columns to be merged (IF statement maybe).

So if the ID does not match the 1st data source, instead of giving a blank I want it to look for the name in the next data source.

E.g. (Name[source1]IF blank=check name[source2]IF blank=check [source3] etc.....

Cheers.

Tags (2)
1 Solution

Accepted Solutions

Re: Fill expression IF left blank

May be this

If(Len(Trim(Name_Source1)) > 0, Name_Source1,

     If(Len(Trim(Name_Source2)) > 0, Name_Source2,

          If(Len(Trim(Name_Source3)) > 0, Name_Source3, Name_Source4)))

2 Replies

Re: Fill expression IF left blank

May be this

If(Len(Trim(Name_Source1)) > 0, Name_Source1,

     If(Len(Trim(Name_Source2)) > 0, Name_Source2,

          If(Len(Trim(Name_Source3)) > 0, Name_Source3, Name_Source4)))

robin_heijt
Contributor

Re: Fill expression IF left blank

Thank you so much!

That worked perfectly!

Appreciate the help.