Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
samane_ramezani
Creator
Creator

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

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
marioglasmv
Partner
Partner

Maybe you can try the following.

Logo:

BUNDLE LOAD

       OrgId,

        Address

FROM ...

Change it to:

Logo:

BUNDLE LOAD

       OrgId               AS ParentOrgID,

       Address

FROM ...

tyagishaila
Specialist
Specialist

Is it okay?

Not applicable

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
Creator
Creator
Author

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
Master
Master

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
Specialist
Specialist

You can write conditional expression in Layout Tab

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

or according to your requirement.

samane_ramezani
Creator
Creator
Author

it doesn't work

tresesco
MVP
MVP

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