certain rows in listbox

[#1]

hi,

first i'll show you my script:

---------

user:

load upper(sachbearbeiter) as user

        user.sachbearbeitername as username

from user.qvd

-----------

------------

articles:

load article

         article.name

          article.group

          if (article.productmanager = ' ' , '[undefined]' , upper(article.productmanager)) as productmanager

from articles.qvd

------------

-----------

productmanagers:

load   user as productmanager

          username as productmanagername

resident user;

concatenate

load * inline

" productmanager, productmanagername

     [undefined], '[undefined]' ";

------------------

productmanager is a short expression for the whole name with two letters, for example: productmanagername: max mustermann - productmanager: mm. (article.productmanager is also the short expression)

there are hundreds of productmanagerNames and only a few 'article.productmanagers'

now i want the listbox to show the productmanagersNames but only these who are 'article.productmangers'. is this possible?

thank you very much!! :-))

[alexandros17]

Hi Dominik,

could you attach your document?

[sasikanth]

hi

try some thing like below

Aggr(if(Not isNull(article.productmanager),productmanagername), productmanagername)

[PradeepReddy]

Try some thing like this...

In Script:

articles:

load article

         article.name

          article.group

          if (article.productmanager = ' ' , '[undefined]' , upper(article.productmanager)) as productmanager,

          if (article.productmanager = ' ' , '[undefined]' , APM)) as IND,

from articles.qvd

Then create a list box with the expression

IF(IND='APM',productmanager)