Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Can I add label to lines inside chart?

Hi experts,

        I would like to add labels to three lines in my chart. I wanted the label to be in the same distance above corresponding line. for examplem UCL is above the first red line on the left.  Is that possible?

        I hope I can  add sample size to the label of x axis to make the label like 201102(33), 201103(78). I cannot think any idea to make this happen. Can it be done.

Thanks

Longmatch

Tags (2)
1 Solution

Accepted Solutions

Re: Can I add label to lines inside chart?

See attached example.


talk is cheap, supply exceeds demand
9 Replies

Re: Can I add label to lines inside chart?

See attached example.


talk is cheap, supply exceeds demand
Not applicable

Re: Can I add label to lines inside chart?

I thought it is not possible and acutally it is. Thanks. Could you give me more explanations about how you got this impossible thing done. It looks like that it need a new expression and dual function. What is the logic? Sorry about the ignorance.

Re: Can I add label to lines inside chart?

We want a label to be displayed on the left of the chart. We make sure of this with if(Month='Jan', ...) so that only for the first value on the x-axis dimension a value is displayed. And we want the label displayed above (or below) the relevant line. So we calculate a value using the expression of the line + a number: 10000+sum({<Year={2008}>}Sales). Using the column name of the line works too: 10000+[2008]. We enable the option Values on Data Points for the label expression. But this will display the value of 10000+[2008] instead of a label. That's where the dual function comes in. It creates a dual value with a text representation and a number representation. The result is that instead of the numeric value the text 'Label2008' is displayed.


talk is cheap, supply exceeds demand
Not applicable

Re: Can I add label to lines inside chart?

Is there any way to remove or hide the symbol under the text added? There is a colorful shape under the text which I really do not want it to show. Thanks

Re: Can I add label to lines inside chart?

Ah, forgot to mention that. Click on the + in front of the expression, select Background Color and type red(0) in the Definition text box. The 0 means use an alpha value of 0, which makes it 100% transparant.


talk is cheap, supply exceeds demand
Not applicable

Re: Can I add label to lines inside chart?

Works perfectly. Thanks

Not applicable

Re: Can I add label to lines inside chart?

Hi,

and is it possible to display bundle image instead of text Lable 2008. Generally is it possible to display image in line chart like some kind of trigger notation.

Thank you,

Milan

Not applicable

Re: Can I add label to lines inside chart?

Hi G Wassenaar,

I want to circle the points with lowest count in a line graph...I used this expression ...

=if(TOTAL_COUNT=min({$}TOTAL_COUNT),dual('LOW',TOTAL_COUNT)) ...

I am getting a continous red line ...Please see the imageLOW.bmp

chaudharic3333
New Contributor

Re: Can I add label to lines inside chart?

I can't see the Dual function in the script? Am I missing something?

Community Browser