QlikView App Dev

[Anonymous]

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

[matt_crowther · Accepted solution]

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

[Anonymous]

Thank you so much for your help!

[#4]

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? 

[#5]

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?