Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

amit_saini
Honored Contributor III

List box string help???

Hi Folks,

Looking for help below:

I'm having list box like below as calculates expression

=if (not isnull(PLANT),PLANT & ' - ' & NAME1)

Here PLANT = Plant numbers and NAME1 = Plant Description.

How to show values in the list box starting with 5* along withdescription?????

Thanks,

AS

1 Solution

Accepted Solutions
MVP
MVP

Re: List box string help???

Hi

=if(Left(PLANT, 1) = '5', PLANT & ' - ' & NAME1)

This will also exclude nulls

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
MVP
MVP

Re: List box string help???

Hi

=if(Left(PLANT, 1) = '5', PLANT & ' - ' & NAME1)

This will also exclude nulls

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

amit_saini
Honored Contributor III

Re: List box string help???

Jonathan,

Thank u for your help.

Just want to ask you one more thing , Suppose I do have some plant number(i.e PLANT) not having description (i.e. NAME1) , so is there any way to show only  those Plant numbers having description in list box????

Thanks,

AS

MVP
MVP

Re: List box string help???

One more check would help there. May be like:

=if(Len(Trim(NAME1))>0 and Left(PLANT, 1) = '5', PLANT & ' - ' & NAME1)