topic Bundle Info Load in QlikView

Bundle Info Load

Anonymous — Wed, 11 Jan 2012 15:48:09 GMT

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

Re: Bundle Info Load

matt_crowther — Wed, 11 Jan 2012 16:20:21 GMT

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

Bundle Info Load

Anonymous — Wed, 11 Jan 2012 16:24:42 GMT

Thank you so much for your help!

Re: Bundle Info Load

Sun, 31 Mar 2013 15:20:00 GMT

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?

Re: Bundle Info Load

Sun, 31 Mar 2013 15:22:06 GMT

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?