topic Re: Display two values for one column? in QlikView

Display two values for one column?

datanibbler — Tue, 14 Jan 2014 14:18:46 GMT

Hi,

in one of my combo_charts, discrete events are displayed, each of which has a certain amount attached to it.

Right now, I am stuck with displaying the amount in € on a time_axis.

<=> That information is somewhat incomplete without the info of how many events contributed to that amount.

Is there any way, without adding a second column per day, to display both those informations?

Thanks a lot!

Best regards,

DataNibbler

Re: Display two values for one column?

bruno_m_santos — Tue, 14 Jan 2014 14:22:58 GMT

If I understood you question, I suggest

Add a second expression and in display option pick Values on Data points.

Bruno

Re: Display two values for one column?

datanibbler — Tue, 14 Jan 2014 14:44:38 GMT

Hi Bruno,

thanks for the answer!

That would be quite easy to do, however. That second column would have to follow another scale, so I'd need another y-axis on the right.

<=> I'd like to do it without a second column, having just the number, if possible inside/ on top of the primary column (underneath the amount in the latter case)

Best regards,

DataNibbler

Re: Re: Display two values for one column?

bruno_m_santos — Tue, 14 Jan 2014 15:11:50 GMT

Is what you need?

Re: Display two values for one column?

richard — Tue, 14 Jan 2014 15:13:42 GMT

The best way to achieve what you want is to to add that second expression, drag the second one over the first one. You will then see a cyclic arrow.

Drag thatr Arrow and put it next to the bars/lines.

This might help the user interpret the data right.