topic Re: List box string help??? in QlikView

List box string help???

amit_saini — Mon, 01 Dec 2014 05:26:51 GMT

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,

Re: List box string help???

jonathandienst — Mon, 01 Dec 2014 05:30:24 GMT

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

This will also exclude nulls

HTH

Jonathan

Re: List box string help???

amit_saini — Mon, 01 Dec 2014 06:36:47 GMT

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,

Re: List box string help???

tresB — Mon, 01 Dec 2014 06:42:21 GMT

One more check would help there. May be like:

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