Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

information about other values in a chart

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

Tags (1)
1 Solution

Accepted Solutions
morgankejerhag
Contributor II

Re: information about other values in a chart

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.

2014-11-20_07-20-12.png

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

8 Replies

Re: information about other values in a chart

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

Not applicable

Re: information about other values in a chart

Hello Bill,

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

Armin

Not applicable

Re: information about other values in a chart

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

Not applicable

Re: information about other values in a chart

attached a screenshot what i have reached2014-11-20_07-09-11.png

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.

danieloberbilli
Valued Contributor II

Re: information about other values in a chart

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])

Not applicable

Re: information about other values in a chart

where should i add this formula?

can you share a screenshot or example?

danieloberbilli
Valued Contributor II

Re: Re: information about other values in a chart

Please find QVW attached

Capture19.PNG.png

morgankejerhag
Contributor II

Re: information about other values in a chart

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.

2014-11-20_07-20-12.png

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

Community Browser