topic Re: Displaying Attributes on Bar Charts in QlikView

Displaying Attributes on Bar Charts

Anonymous — Fri, 31 May 2013 10:25:44 GMT

I have a simple bar charts that has two dimension, date and the sector and one expression which is the performance. The Date is the x-axis and the performance as the y-axis. The dimension limit is set on the sector to show only the largest performaning sector.

The aim of the chart is to show the best performing sector each day. However as the x-axis is the date and the y-axis is the performance I would like to show the sector on each bar? How can I do this? I can show the performance number on each Bar by selecting (Values on Data Points) on the performance expression. Is there anyway to show the sector on each Bar?

Re: Displaying Attributes on Bar Charts

Gysbert_Wassenaar — Fri, 31 May 2013 10:34:12 GMT

You can probably use the dual() function for this. It creates a dual value with a text and a number representation. Change your expression to something like dual( Sector, myexpression ). If you want both the sector and the performance shown you can try something like

dual( Sector & ': '& myexpression , myexpression )

Re: Displaying Attributes on Bar Charts

Anonymous — Fri, 31 May 2013 10:49:06 GMT

Thanks Gysbert

Maybe I'm doing something wrong as I can't seem to see any difference when using the dual() function.

I've changed the expression as you suggested to Dual(Sector & ':' & Sum(performance), sum(performance)).

But the bar chart still just shows the performance (i.e. SUM(Performance)).

I also added the same expression to the Show Value property of the Expression, but it made no difference.

Re: Displaying Attributes on Bar Charts

Gysbert_Wassenaar — Fri, 31 May 2013 11:07:21 GMT

Ah, yes. You'd need to enable plot values inside segments to show the dual value. But that probably doesn't look very pretty. You can use a combi chart with a second expression to show the dual values. See attached example.

Re: Displaying Attributes on Bar Charts

Anonymous — Fri, 31 May 2013 11:24:56 GMT

Nearly Perfect Gysbert

Thank you for the example - that works well.

But is it possible for the text(sector names) to be aligned verticaly on top of the Bar, as some of the sector names are long?

Re: Displaying Attributes on Bar Charts

Gysbert_Wassenaar — Fri, 31 May 2013 11:54:48 GMT

Check the option Vertical on the Presentation tab (in the Values on Data Points section) to show the values vertically.

A better option may be to change the orientation of the bar chart so the bars are displayed horizontally. That's probably a lot easier to read.

Re: Displaying Attributes on Bar Charts

Anonymous — Fri, 31 May 2013 11:55:58 GMT

Perfect - that is very helpful - thank you very much.