Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
amit_saini
Honored Contributor 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

Re: List box issue

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.
3 Replies

Re: List box issue

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.

Re: List box issue

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
Valued Contributor III

Re: List box issue

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

Community Browser