Show just first Level Logo in ListBox

[Anonymous]

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

[marioglasmv]

Maybe you can try the following.

Logo:

BUNDLE LOAD

       OrgId,

        Address

FROM ...

Change it to:

Logo:

BUNDLE LOAD

       OrgId               AS ParentOrgID,

       Address

FROM ...

[tyagishaila]

Is it okay?

[#4 · Accepted solution]

Please use

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

and In presentation
representation as "Image"

[Anonymous]

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

[beck_bakytbek]

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

[tyagishaila]

You can write conditional expression in Layout Tab

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

or according to your requirement.

[Anonymous]

it doesn't work

[tresesco]

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