topic Re: information about other values in a chart in QlikView

information about other values in a chart

Wed, 19 Nov 2014 16:01:13 GMT

Hello,

I have made a bar chart with amount on the y axis and the article name on the x-axis. Now i would like to add informations in the bar chart from another variable. This means i would like to add into the chart the values of the costs to each bar.

Thanks, Armin

Re: information about other values in a chart

Anonymous — Wed, 19 Nov 2014 19:52:21 GMT

You could put them on the top of the bars like this :

Re: information about other values in a chart

Thu, 20 Nov 2014 06:03:55 GMT

Hello Bill,

That's what i also found, but i would like to see both values.

Armin

Re: information about other values in a chart

Thu, 20 Nov 2014 06:07:57 GMT

Could you share the sample app and requirements a bit more clarify

Re: information about other values in a chart

Thu, 20 Nov 2014 06:12:15 GMT

attached a screenshot what i have reached

but i would like to have the value 4.486,30 € in the same style as the 200000 and beside the 200000 or inside the bar.

Re: information about other values in a chart

danieloberbilli — Thu, 20 Nov 2014 06:12:48 GMT

To use the example from Bill: you can show both values on top just by adding the first expression:

sum([Fact One] & ... & Sum([Fact Two])

Re: information about other values in a chart

Thu, 20 Nov 2014 06:18:07 GMT

where should i add this formula?

can you share a screenshot or example?

Re: Re: information about other values in a chart

danieloberbilli — Thu, 20 Nov 2014 06:19:16 GMT

Please find QVW attached

Re: information about other values in a chart

morgankejerhag — Thu, 20 Nov 2014 06:20:55 GMT

Make your chart a combination chart and add a second dimension without bars or lines. Only add the expression for the values you want tot show:

'Val 1: ' & sum(Val1) & chr(13) & 'Val 2: ' & sum(Val2)

See the attached example.

Edit: Daniels post didn't show up first for some reason, but now I see that he already suggested this.