Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master III

List box issue

Hi Folks ,

I'm calling excel sheet with script below:

LOAD  left(A,3) as Plant,

     B as Region,

     C as Plant_FullName,

     D as Business_Units

FROM

(ooxml, no labels, table is Sheet1);

In list box I'm calling this expression :

=Plant & ' - ' & Plant_FullName

Output is:

No idea why this '-' is present in list box , Kindly help here I don't want this - in Plant list.

Thanks,

AS

1 Solution

Accepted Solutions
PrashantSangle

Hi,

Change your expression to

if (not isnull(Plant),Plant & ' - ' & Plant_FullName)

or

if (not isnull(Plant) and not isnull(Plant_FullName),Plant & ' - ' & Plant_FullName)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

3 Replies
PrashantSangle

Hi,

Change your expression to

if (not isnull(Plant),Plant & ' - ' & Plant_FullName)

or

if (not isnull(Plant) and not isnull(Plant_FullName),Plant & ' - ' & Plant_FullName)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

PrashantSangle

Hi,

Try this also

if(len(trim(Plant))>0,Plant & ' - ' & Plant_FullName)

or

if(len(trim(Plant))>0 And len(trim(Plant_FullName))>0,Plant & ' - ' & Plant_FullName)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
senpradip007
Specialist III
Specialist III

Could you please upload sample qvw? I think Plant and Plant_FullName contain any null value.