Display a second value inside a column?

datanibbler — Mon, 02 Sep 2013 09:52:58 GMT

Hi,

I am just building a diagram for HR data and I am facing the difficulty that

=> I am already using two scales (one left, one right), but there is one more value I would like to display simultaneously, but it won't fit in either of the scales. More precisely, I have

- the total nr. of employees (scale from 100 to 1000 on the left) and

- the percentage of men and women (scale in % on the right)

=> The next (which should be displayed in the same view) would be the avg. age...

My question is: Can I use the formula_properties dialog to display inside every column (one per month) two values,

- one just representing the same thing as the column does (acc. to the scale)

- one calculated by a different formula, having nothing to do with the scale

Thanks a lot!

Best regards,

DataNibbler

Re: Display a second value inside a column?

Oleg_Troyansky — Tue, 03 Sep 2013 00:57:35 GMT

You can experiment with the function Dual():

- Assign the value that you wanted to show inside the bars, to the textual part of Dual.

- Assign the same numeric value as the Bar's original expression, to the numeric part of Dual.

- Uncheck any graphical representation for the new expression and check "Values on Data Points"

- To show the values inside bars, select "Plot Values Inside Segments" on the Presentation tab.

You should be able to see the desired numbers plotted within the original bars.

cheers,

Oleg Troyansky

topic Display a second value inside a column? in QlikView

Display a second value inside a column?

Re: Display a second value inside a column?