Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted
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 ...

Highlighted
tyagishaila
Valued Contributor

Re: Show just first Level Logo in ListBox

Is it okay?

Highlighted
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

Highlighted
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

Highlighted
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

Highlighted
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.

Highlighted
samane_ramezani
Contributor

Re: Show just first Level Logo in ListBox

it doesn't work

Highlighted
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.