Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
jenstarr
New Contributor III

Bundle Info Load

I have successfully brought images into a dashboard and now I'm struggling with linking those images with the data.  Attached is a sample dashboard of what I'm working with.  I would like to visually show the number of people in each department. 

Thanks for you help!

Jen

1 Solution

Accepted Solutions
Luminary
Luminary

Re: Bundle Info Load

Jen,

Looks as though your issue is that you're only generating the count of people in the department in your actual chart...and the result isn't associated with the People value or the corresponding 'info' image.

I've re-worked your script; primarily to include a resident group by load to calculate the number of people in each Department in the load script to create an actual figure to associate to.

Data:
Load * Inline [

id, dep
aaa, marketing
aba, marketing
bbb, sales
ccc, admin
ddd, accounting
dde, accounting
ddf, accounting
ddg, accounting
];

Left Join (Data)
Load dep,
count(id) as People
Resident Data Group By dep;

Info:
BUNDLE INFO LOAD
People,
'..\Pictures\images\' & People & 'people.png'
RESIDENT Data;

The above is untested as I don't have the images locally.

Hopefully that will get you there.

All the best,

Matt - Visual Analytics Ltd

@QlikviewBI

4 Replies
Luminary
Luminary

Re: Bundle Info Load

Jen,

Looks as though your issue is that you're only generating the count of people in the department in your actual chart...and the result isn't associated with the People value or the corresponding 'info' image.

I've re-worked your script; primarily to include a resident group by load to calculate the number of people in each Department in the load script to create an actual figure to associate to.

Data:
Load * Inline [

id, dep
aaa, marketing
aba, marketing
bbb, sales
ccc, admin
ddd, accounting
dde, accounting
ddf, accounting
ddg, accounting
];

Left Join (Data)
Load dep,
count(id) as People
Resident Data Group By dep;

Info:
BUNDLE INFO LOAD
People,
'..\Pictures\images\' & People & 'people.png'
RESIDENT Data;

The above is untested as I don't have the images locally.

Hopefully that will get you there.

All the best,

Matt - Visual Analytics Ltd

@QlikviewBI

jenstarr
New Contributor III

Bundle Info Load

Thank you so much for your help!

Not applicable

Re: Bundle Info Load

Hi jen

You have imported images from a specified path by using script editor..

Pictures\images\' & People & 'people.png'

how to get images through script editor??

Could You Please Help Me? 


Not applicable

Re: Bundle Info Load

Hi Matthew,

Really Ur code is fine.. 

I have one doubt..

--------------------------------------------------------------

You have imported images from a specified path by using script editor..

Pictures\images\' & People & 'people.png'

how to get images through script editor??

Could You Please Help Me?