topic Re: Caption on Block Chart in QlikView

Caption on Block Chart

qlikvw2019 — Wed, 25 Nov 2020 16:16:04 GMT

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"

Re: Caption on Block Chart

Frank_Hartmann — Mon, 21 Oct 2019 20:34:05 GMT

see attached

hope this helps

Re: Caption on Block Chart

qlikvw2019 — Tue, 22 Oct 2019 01:55:56 GMT

Hi

Thankyou for your response.

I dont see the changes reflected on the chart

Re: Caption on Block Chart

Frank_Hartmann — Tue, 22 Oct 2019 06:54:56 GMT

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

I see: BLDG2 , SIZE=800

Re: Caption on Block Chart

qlikvw2019 — Tue, 22 Oct 2019 10:09:36 GMT

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

Re: Caption on Block Chart

Arthur_Fong — Tue, 22 Oct 2019 16:12:56 GMT

There you go:

In Presentation > check show dimension labels.

Thanks and regards,

Arthur Fong

Re: Caption on Block Chart

qlikvw2019 — Tue, 22 Oct 2019 22:26:03 GMT

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

Re: Caption on Block Chart

Arthur_Fong — Wed, 23 Oct 2019 00:08:28 GMT

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

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

Re: Caption on Block Chart

qlikvw2019 — Thu, 24 Oct 2019 16:57:02 GMT

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

Re: Caption on Block Chart

Arthur_Fong — Thu, 24 Oct 2019 23:56:53 GMT

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

Re: Caption on Block Chart

Natalie49 — Sat, 26 Oct 2019 05:08:31 GMT

You should try to encapsulate the entire story the chart is telling you. The caption occupies the top-most place in a chart, and the user can know what to look for in the chart. For instance, in the chart below, the caption doesn’t tell the user what the comparison is about Dollar General Customer Satisfaction Survey

Re: Caption on Block Chart

qlikvw2019 — Sat, 26 Oct 2019 03:45:09 GMT

Thankyou Arthur.

I copied the 2 lines ,but i am not getting the same output.

Re: Caption on Block Chart

Arthur_Fong — Tue, 29 Oct 2019 00:28:49 GMT

Modified expression 2 to be:

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

Click on the chart, then click on shift+ctrl to start shifting the position of the textbox.

Thanks and regards,

Arthur Fong

Re: Caption on Block Chart

Brett_Bleess — Wed, 30 Oct 2019 18:32:27 GMT

Nazneen, do not forget to come back and use the Accept as Solution button on the post(s) that helped you with things, quite a few folks that appear to deserve credit on this one, so be sure to circle back and do that so they do get credit and folks know which ones actually helped too. If you have further questions leave an update, otherwise just be sure to mark the posts that did help, you can mark more than one, just FYI.

Regards,
Brett