Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikvw2019
Contributor
Contributor

Caption on Block Chart

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"

 

 

Capture.JPG

13 Replies
Frank_Hartmann
Master II
Master II

see attached Unbenannt.png

hope this helps

qlikvw2019
Contributor
Contributor
Author

Hi

Thankyou for your response.

I dont see the changes reflected on the chart
Frank_Hartmann
Master II
Master II

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

I see: BLDG2 , SIZE=800

qlikvw2019
Contributor
Contributor
Author

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
Partner - Specialist III
Partner - Specialist III

There you go:

Block Chart.PNG

In Presentation > check show dimension labels.

Thanks and regards,

Arthur Fong

qlikvw2019
Contributor
Contributor
Author

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
Partner - Specialist III
Partner - Specialist III

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

Block Chart.PNG

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

qlikvw2019
Contributor
Contributor
Author

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
Partner - Specialist III
Partner - Specialist III

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