topic Re: Labels on graphs with different data than represented by the bars in QlikView

Labels on graphs with different data than represented by the bars

Fri, 31 Jan 2014 08:42:34 GMT

Hi,

I made a bar stacked bar chart, with data on the on time arrival of trucks. I'm showing what percentage of trucks arrive on time, what percentage within 30 minuts of their booked time, which within 60 minutes, etc. So I made the following expressions in my chart:

1) =sum[On time]) / Count[PO Number])
2) =sum[On time + 30]) / Count[PO Number]) - sum[On time]) / Count[PO Number])

3) =sum[On time + 60]) - sum[On time + 30])

4) etc.

(When the goods are on time, I gave it the value of 1, if late 0 in mij [On time], that's why I can do the sum formula)

So my bars represent percentages, but as labels I want to put the actual number PO numbers related to the parts of my stacked bars. How do I do this?

Re: Labels on graphs with different data than represented by the bars

Gysbert_Wassenaar — Fri, 31 Jan 2014 08:45:58 GMT

You can use the dual function for this. Something like dual( Count[PO Number] , sum[On time]) / Count[PO Number]) )

Re: Labels on graphs with different data than represented by the bars

Fri, 31 Jan 2014 09:04:50 GMT

Hi Gysbert,

Thank you for your help. I see that if I use this formula, when I press the charts, it switches between the two datasets. So it does not exactly do what I hoped for, but it is an alternative if it is not possible to put different datalabels on the chart.

However, if I make this switch, my Y-axis still shows the data as a percentage (so in stead of 700 loads, it shows 700%). How do I let the chart itself change too?

Re: Labels on graphs with different data than represented by the bars

Fri, 31 Jan 2014 09:09:25 GMT

Insert a conditional number format with an if statement:

ie.

if(....,num(....,'#.##0'),num(....,'#.##0%')