Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Working with Image

Hi, i I have an image of a plane, and i want to used to mark which space is rented with red and which is free with green and show somo data about the space. How i can do it.

I attach the image.

TKS

2 Replies

Re: Working with Image

Does this help:

Qlik Branch

Feeling Qlikngry?

How To /Missing Manual(25 articles)

sandipsatbhai
Contributor II

Re: Working with Image

Hi Victor,

try this...

Load your plan status using below script..

LOAD * INLINE [

    Number, Rent Flag

    1, 1

    2, 0

    3, 1

    4, 0

    5, 0

    6, 0

    7, 1

    8, 1

    9, 1

    10, 1

];

1) keep you image at the background of one text box and keep that text box at the bottom level.

2)then create one text box for each block of plane with 2 rounded corners.

3) in the background color of text box use calculated color with the below expressions

for 1st block =if(sum({<Number={1}>}[Rent Flag])>0,Green(),red())

for 2nd block =if(sum({<Number={2}>}[Rent Flag])>0,Green(),red())

and so on for each block..

4)you can also add other information if you want as i added text inside each text box..

out put:

Img1.PNG