Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master 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
jonathandienst
Partner - Champion III
Partner - Champion III

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
jonathandienst
Partner - Champion III
Partner - Champion III

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
amit_saini
Master III
Master III
Author

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

tresesco
MVP
MVP

One more check would help there. May be like:

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