Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
prees959
Creator II
Creator II

Section Access - Images

HI, I'm section Access to reduce the data in a document using NTName and a field called Site Code.

I would like to switch the logo on the landing page according to the Site Code of the user.

My section access table is :

     

ACCESSNTNAME%SITE_CODE
ADMINDOMAIN\Joe.BloggsABC
USERDOMAIN\Joe.DoeDEF

I then have the following section application table

      

Site Code%SITE_CODEIMG Code
ABCABCABC
DEFDEFDEF

In my application i have the following bundle load:

Images:

Bundle

Load

     [Image Name],

     [Image Location]

FROM

(ooxml, embedded labels, table is IMAGES);

Which reads in this table with the image location:

  

Image NameImage Location
ABCC:\QVAPPS\Images\ABC_LOGO.jpg
DEFC:\QVAPPS\Images\DEF_LOGO.jpg

Can anyone help with the next steps of setting the logo correctly when the user logs in?

Many thanks,

Phil

9 Replies
avinashelite

1.use a text object and expanded it your desired height and width

2.Use an conditional expression if([IMG Code]='ABC',image1path,imgae2path)

jyothish8807
Master II
Master II

Hi Phil,

Create a text box and with required width and height --> propety 'As keep aspect" -->Representation  as Image

exp: info([Image Name]


Since you have section access and each user have access to only one site, so i info([Image Name] would be enough.


Br,

KC

Best Regards,
KC
jyothish8807
Master II
Master II

Also do a info load

Bundle Info

Load

     [Image Name],

     [Image Location]

FROM

(ooxml, embedded labels, table is IMAGES);

Best Regards,
KC
prees959
Creator II
Creator II
Author

HI,

Thanks for the reply.   But I could have upto 50 different sites in future... is there a more dynamic way?

prees959
Creator II
Creator II
Author

Hi,

Is this instead of the Bundle Load or as well as the Bundle Load?

avinashelite

In that case tag the user and site column so that when the user login the site column will get defined and in the image path place all the 50site images and based on login user you will get the site name > just use that to define the image

//C:Image_folder/$(vImage)

vimage = maxstring(Site)

prees959
Creator II
Creator II
Author

Hi again,

This doesnt seem to be working, I have set myself as ABC and the document reduces to this Site when I open it.

If I place an IMG Code list box it's showing ABC.  But if a place an Image Name list Box it's showing ABC and DEF...

Hope you can help,

Phil

jyothish8807
Master II
Master II

have you tried adding  "info" in your bundle load ?

may be you can try setting a trigger on open --> Select in field -- Image Name


Exp in text box -- info([Image Name])

Best Regards,
KC
jyothish8807
Master II
Master II

Hi Phil,

Refer the attached.

1. User Name - A

    Password - 11

2. User name -B

Password - 22

Best Regards,
KC