topic Re: certain rows in listbox in QlikView

certain rows in listbox

Mon, 14 Jul 2014 13:31:56 GMT

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!! :-))

Re: certain rows in listbox

alexandros17 — Mon, 14 Jul 2014 13:40:03 GMT

Hi Dominik,

could you attach your document?

Re: certain rows in listbox

sasikanth — Mon, 14 Jul 2014 13:42:13 GMT

try some thing like below

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

Re: certain rows in listbox

PradeepReddy — Mon, 14 Jul 2014 13:47:06 GMT

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)