topic Re: Show just first Level Logo in ListBox in QlikView

Show just first Level Logo in ListBox

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Qliker

I have hierarchy of organization in my doc.

and load the first level of organization's logo by 'bundle load' in qlikview

but when I write a expression in listBox to show just the first level organization Logo, it doesn't work

Can anyone help me to show just first level Organization's logo

to show what is my purpose I prepare a sample in qlikview

Re: Show just first Level Logo in ListBox

marioglasmv — Wed, 01 Mar 2017 06:36:12 GMT

Maybe you can try the following.

Logo:

BUNDLE LOAD

OrgId,

Address

FROM ...

Change it to:

Logo:

BUNDLE LOAD

OrgId AS ParentOrgID,

Address

FROM ...

Re: Show just first Level Logo in ListBox

tyagishaila — Wed, 01 Mar 2017 06:38:36 GMT

Is it okay?

Re: Show just first Level Logo in ListBox

Wed, 01 Mar 2017 06:52:52 GMT

Please use

In List box General tab field expression as the below
"=if(IsNull(ParentOrgID)=-1,Info(OrgId))"

and In presentation
representation as "Image"

Re: Show just first Level Logo in ListBox

Anonymous — Wed, 01 Mar 2017 07:29:52 GMT

when it was in clear state it show all organizations

and the number of my organizations in each level is dynamic

so your solution didn't help me unfortunately

Re: Show just first Level Logo in ListBox

beck_bakytbek — Wed, 01 Mar 2017 08:04:14 GMT

Hi Samane,

look at this:

1: Load Multiple Images to QlikView

2. QlikView Technical Brief - Loading Images into QlikView.zip

i hope that helps to resolve your issue

beck

Re: Show just first Level Logo in ListBox

tyagishaila — Wed, 01 Mar 2017 08:51:00 GMT

You can write conditional expression in Layout Tab

=if(GetFieldSelections(OrgId)>0,1,0)

or according to your requirement.

Re: Show just first Level Logo in ListBox

Anonymous — Wed, 01 Mar 2017 08:54:15 GMT

it doesn't work

Re: Show just first Level Logo in ListBox

tresB — Wed, 01 Mar 2017 09:09:01 GMT

The way Ravindra has shown above should work. Please retry and follow the steps properly.