Use of a Silent Legend - Qlik Community

Jennell_McIntire · ‎2013-01-18

When creating a chart in QlikView that has multiple expressions, a legend is created for each expression. Sometimes, I find that the legend takes up too much space and I spend time trying to move it or adjust the wording in my expression labels so that they are not too long just so I can show my chart and gain as much real estate on my sheet as possible. Now I have the option to turn the expression legends off but without them you will have no idea what the chart is showing. So I explored other ways to show a legend without cluttering my sheet. In the Social Media Data Analysis demo, I had several visualizations that compared six companies. If I used the expression legend in the line chart and the bar chart (Tweets over time section), it would have taken up a lot of space and been a little redundant as seen in the image below.

So instead, I added a silent legend to the Company List Box by adding Text Objects that corresponded to each company. I set the style of the List Box to LED so that the companies were always listed in the same order and I added actions to the Text Objects so that users could make selections using either the company name or color. This allowed me to remove the expression legends in my line and bar chart enabling me to show more of the data and it gave the charts a cleaner appearance.

There are other examples of silent legends in the Asset Management and Help Desk Management demos. In the Asset Management demo, the legend is defined in the asset class headings and coloring is reflected in the pie and bar charts.

The Help Desk Management demo uses the List Box as the legend and the respective colors in a straight table versus using the text. This makes the various priorities easier to identify in the list.

I have written a technical brief on how a silent legend was created in these three demos. Check it out.

Anonymous · ‎2013-01-18

Loved the clean solution. Very elegant way.

Congrats.

Report Inappropriate Content · ‎2013-01-20

Great way for space optimization. Liked it!

Regards,

-Khaled.

Report Inappropriate Content · ‎2013-01-21

Good one.

kouroshkarimi · ‎2013-01-21

An excellent concept, but I would caveat it slightly - the colours in your Social Media document are very distinctive which is important if you wish for this approach to be effective. Using one colour with different hues or chroma such as in the last example isn't the best way imo, as it makes it difficult to differentiate 'at a glance'. It will also make it difficult if users print the sheet in black & white or for the colour-blind.

Also your post has "I have written a Not authorized to view the specified document 3753 on how a silent legend..." should this be the case?

Clever_Anjos · ‎2013-01-21

Very elegant.

Congrats

Report Inappropriate Content · ‎2013-01-21

Its look very nice.

Thanks,

Siri

Jennell_McIntire · ‎2013-01-21

Thanks Siri. You can download all the demos I discussed from demo.qlik.com.

Kind Regards,

Jennell

Jennell_McIntire · ‎2013-01-23

Very good point. Thanks.

The technical brief link should be working now. Thanks for pointing that out to me.

Kind Regards,

Jennell

Report Inappropriate Content · ‎2013-01-31

Great minds think alike. I like this very much. We did something similar recently, but we used a background image, behind the list box, that basically gave color to the entire row. I like this approach a bit more tho, since, I feel, it is a bit more elegant.

Report Inappropriate Content · ‎2013-01-31

Hi Ralph, Can you please provide the procedure how to insert the Background image in List Box?

Thanks in Advance .....