topic Re: Plot value in chart and % in legend in QlikView

Plot value in chart and % in legend

Wed, 06 Jun 2012 16:14:21 GMT

Hi there,

I have plotted the values in my chart but in addition I would like to put the % in the legend..

Also, I have month as my dimension and reference numbers as expression (count), can anyone tell me how I can get the relative figure to add up to 100% per month rather than the total in the data set.

Many thanks all,

Matt

Plot value in chart and % in legend

Mon, 11 Jun 2012 08:48:55 GMT

can anyone help?

Re: Plot value in chart and % in legend

Miguel_Angel_Baeyens — Mon, 11 Jun 2012 09:06:35 GMT

Hi Matt,

To the first question, make your expression labels in the chart properties, Expressions tab, have the expression for the percentage. As a very basic example, the following should go in the expression label:

='Sales % is ' & Num(Sum(Sales) / Sum(TOTAL Sales), '#.##0,00%')

To the second, it depends on how you are creating your chart. Can you upload an example with dummy data on what you already have and what do you expect?

Hope that helps.

Miguel