Caption on Block Chart

[qlikvw2019]

Hello Friends,

I have attached a qlikview chart, its a block chart.  When i hover the mouse on BLDG2, i see the caption as display in the below pic "BLDC=BLDG2 , SIZE=800" .

My question is: How can we have this caption displayed as part of the chart itself when it loads.

Ex. Instead of simply "BLDG2"

I want to have "BLDG2, SIZE=800"

[Frank_Hartmann]

see attached

hope this helps

[qlikvw2019]

Hi

Thankyou for your response.

I dont see the changes reflected on the chart

[Frank_Hartmann]

When you hover the mouse on BLDG2, what do you see?

I see: BLDG2 , SIZE=800

[qlikvw2019]

When i hover the mouse , i do see the same. But thats not what i am looking for. 

What i need is , those captions should be loaded by default and not just when you hover the mouse

[Arthur_Fong]

There you go:

In Presentation > check show dimension labels.

Thanks and regards,

Arthur Fong

[qlikvw2019]

Thankyou Arthur. 

This is exactly what i was looking for. Is it possible to further customize it , it instead of displaying them in brackets , can we have then show in the next line  , with some captions?

ex: BLDG2

SIZE=800

[Arthur_Fong]

Instead of checking show numbers in labels,  add both lines using text in chart.

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

[qlikvw2019]

Hi Arthur,

This is absolutely great.  It works exactly as expected.

Can you please explain the code, i am trying to get the logic and have no clue. Thanks

[Arthur_Fong]

I sliced the logic into 2 different fonts:

='INSERT CAPTION: '&if(GetSelectedCount(BLDG)>=1 and GetSelectedCount(ROOM)>=1,IF(ISNULL(MAX(CUBICLE_SIZE,2)),'',MAX(CUBICLE_SIZE,1)),IF(ISNULL(MAX(ROOMSIZE,1)),'',MAX(ROOMSIZE,2)))

First Logic:

if(GetSelectedCount(BLDG)>=1 and GetSelectedCount(ROOM)>=1,IF(ISNULL(MAX(CUBICLE_SIZE,1)),'',MAX(CUBICLE_SIZE,1)),

>If both BLDG and ROOM is selected,  if there is no max value for CUBICLE_SIZE, display null, else return the first max value for CUBICLE_SIZE,

Second Logic:

,IF(ISNULL(MAX(ROOMSIZE,1)),'',MAX(ROOMSIZE,1)))

>If only BLDG is selected, if there is no max value for ROOMSIZE, display null, else return the first max value for ROOMSIZE.

MAX(ROOMSIZE,1) and MAX(ROOMSIZE,2)

>Return the first max value of roomsize for the first block, which is the largest block.

>Return the second max value of roomsize for the first block, which is the second largest block.

Thanks and regards,

Arthur Fong