topic Re: How to show legend/data label directly in chart area? in QlikView

How to show legend/data label directly in chart area?

Anonymous — Mon, 23 May 2016 15:44:47 GMT

Hi, I want to show Data Label in the chart like this:

tried the trick with second expression as value data point but didn't work correctly. If that second expression is enabled, the chart won't show correctly in categories.

Re: How to show legend/data label directly in chart area?

ThornOfCrowns — Mon, 23 May 2016 15:55:04 GMT

You can either add the Text to the chart using the Presentation Tab or use DUAL if you have very dynamic information.

Re: How to show legend/data label directly in chart area?

Anonymous — Mon, 23 May 2016 15:59:02 GMT

Hi
try this

Add a new line chart. Add two dimensions, Date and Country.
Add the following expression:

Dual(

If(Date=Max(total Date), Country, ''),

Sum(Sales)

}

On the Expressions tab, ensure that the Values on Data Points option is checked.
Click on Next until you get to the Presentation tab. Deselect the Show Legend option

Re: How to show legend/data label directly in chart area?

Anonymous — Mon, 23 May 2016 16:16:09 GMT

Dual seems promising. Looked around in the forum but I need help to explain the logic of the Dual statement.

Can you provide example?

I've checked this: Dual Function in a line graph

Re: How to show legend/data label directly in chart area?

Anonymous — Mon, 23 May 2016 18:48:27 GMT

In my example:

Dual(If(Date=Max(total Date), Country, ''),Sum(Sales))

The Dual function will only return a text value when the date matches the maximum date. Otherwise, it is blank. So, when we enable the Values on Data Points option, it only displays a value for the last data point.

Syntax:

Dual(text, number)

The dual() function allows us to specify the individual text and number parts to be combined into a single dual value:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/FormattingFunctions/Dual.htm

Qlik Tips: Using Dual

dual function() | Qlik Community

Re: How to show legend/data label directly in chart area?

MarcoWedel — Mon, 23 May 2016 19:45:39 GMT

Hi,

maybe helpful:

Re: Trellis chart: How to generate variable y-axes

regards

Marco

Re: How to show legend/data label directly in chart area?

Anonymous — Thu, 26 May 2016 10:45:10 GMT

Your explanation really helps. Thanks!

Unfortunately it only works on something that has maximum value, the original content of period is something like Q1, Q2, etc so I had to work around slightly to get what I want. May be I can enhance the script a bit later, it's not very urgent now.

Lastly the overlying text, I recall reading somewhere in the community that we can't do anything about it, can we?

Re: How to show legend/data label directly in chart area?

Anonymous — Thu, 26 May 2016 11:56:17 GMT

Hi,

If you expand(drag) your graph , this overlaying of text will be minimized .

It seems you need 'country name' on maximum sales ??

would you please post your examplet data or qvw file .

so that , I can help you ..

Regards

Allu