topic Re: Section Access - Images in QlikView

Section Access - Images

prees959 — Wed, 25 Nov 2020 16:16:04 GMT

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 :

ACCESS	NTNAME	%SITE_CODE
ADMIN	DOMAIN\Joe.Bloggs	ABC
USER	DOMAIN\Joe.Doe	DEF

I then have the following section application table

Site Code	%SITE_CODE	IMG Code
ABC	ABC	ABC
DEF	DEF	DEF

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 Name	Image Location
ABC	C:\QVAPPS\Images\ABC_LOGO.jpg
DEF	C:\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

Re: Section Access - Images

avinashelite — Fri, 08 Jun 2018 09:16:06 GMT

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

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

Re: Section Access - Images

jyothish8807 — Fri, 08 Jun 2018 09:26:12 GMT

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,

Re: Section Access - Images

jyothish8807 — Fri, 08 Jun 2018 09:27:42 GMT

Also do a info load

Bundle Info

Load

[Image Name],

[Image Location]

FROM

(ooxml, embedded labels, table is IMAGES);

Re: Section Access - Images

prees959 — Fri, 08 Jun 2018 09:31:04 GMT

HI,

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

Re: Section Access - Images

prees959 — Fri, 08 Jun 2018 09:37:50 GMT

Hi,

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

Re: Section Access - Images

avinashelite — Fri, 08 Jun 2018 09:38:30 GMT

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)

Re: Section Access - Images

prees959 — Fri, 08 Jun 2018 09:42:38 GMT

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

Re: Section Access - Images

jyothish8807 — Fri, 08 Jun 2018 09:47:02 GMT

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])

Re: Section Access - Images

jyothish8807 — Fri, 08 Jun 2018 10:10:44 GMT

Hi Phil,

Refer the attached.

1. User Name - A

Password - 11

2. User name -B

Password - 22