topic Re: Show value in legend - Line Chart in QlikView

Show value in legend - Line Chart

jose_vargas — Mon, 27 Mar 2017 22:50:20 GMT

Hello-

I have a Line Chart for sum amount for each month and year, my legend is year and i need to show the total in legend for each year.

I Attach the image and need to put in the red box the total.

Is that possible? Thanks

Re: Show value in legend - Line Chart

vishsaggi — Mon, 27 Mar 2017 23:16:47 GMT

In your Chart properties -> Presentation tab -> Got to text in chart and add your expression.

=Aggr(Sum(Yourfield), YourYearField)

Like here:

Re: Show value in legend - Line Chart

jose_vargas — Wed, 29 Mar 2017 17:36:09 GMT

Hello, its no work... When i did that, the value show in chart, i need yo show the value in text legend, next to the year in my case.

Re: Show value in legend - Line Chart

vishsaggi — Wed, 29 Mar 2017 18:07:04 GMT

Can you share a sample app to look into?

Re: Show value in legend - Line Chart

jose_vargas — Wed, 29 Mar 2017 21:34:17 GMT

Yes.. Look the legend "Año" (year), i want to show the sum of each year.

Re: Show value in legend - Line Chart

vishsaggi — Thu, 30 Mar 2017 14:03:19 GMT

Check here? Use the sum expression in your Presentation tab Text in chart Add these expressions and drag them to the legend.

= '(' & Sum({< Ano = {'2016'}>} YourExprField) & ')'

= '(' & Sum({< Ano = {'2017'}>} YourExprField) & ')' .....

See attached. Then using ctrl+Shift you will see different Graph objects with Red rectangles like image below, then you can move those numbers to their respective year legend.