topic List box issue in QlikView

List box issue

amit_saini — Wed, 08 Oct 2014 06:15:59 GMT

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,

PrashantSangle — Wed, 08 Oct 2014 06:17:52 GMT

Hi,

Change your expression to

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

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

Regards

PrashantSangle — Wed, 08 Oct 2014 06:19:08 GMT

Hi,

Try this also

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

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

Regards

senpradip007 — Wed, 08 Oct 2014 06:20:17 GMT

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