Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
samane_ramezani
Contributor

Show just first Level Logo in ListBox

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

1 Solution

Accepted Solutions
Not applicable

Re: Show just first Level Logo in ListBox

Please use

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

and In presentation
representation as "Image"11.PNG

22.PNG

View solution in original post

8 Replies
Partner
Partner

Re: Show just first Level Logo in ListBox

Maybe you can try the following.

Logo:

BUNDLE LOAD

       OrgId,

        Address

FROM ...

Change it to:

Logo:

BUNDLE LOAD

       OrgId               AS ParentOrgID,

       Address

FROM ...

tyagishaila
Valued Contributor

Re: Show just first Level Logo in ListBox

Is it okay?

Not applicable

Re: Show just first Level Logo in ListBox

Please use

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

and In presentation
representation as "Image"11.PNG

22.PNG

View solution in original post

samane_ramezani
Contributor

Re: Show just first Level Logo in ListBox

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
Honored Contributor

Re: Show just first Level Logo in ListBox

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
Valued Contributor

Re: Show just first Level Logo in ListBox

You can write conditional expression in Layout Tab

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

or according to your requirement.

samane_ramezani
Contributor

Re: Show just first Level Logo in ListBox

it doesn't work

MVP
MVP

Re: Show just first Level Logo in ListBox

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