topic Re: Can I add label to lines inside chart? in QlikView

Can I add label to lines inside chart?

Fri, 08 Mar 2013 19:48:58 GMT

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

Re: Can I add label to lines inside chart?

Gysbert_Wassenaar — Sat, 09 Mar 2013 09:18:20 GMT

See attached example.

Re: Can I add label to lines inside chart?

Sat, 09 Mar 2013 19:47:09 GMT

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?

Gysbert_Wassenaar — Sun, 10 Mar 2013 09:40:04 GMT

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.

Re: Can I add label to lines inside chart?

Wed, 13 Mar 2013 15:18:54 GMT

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?

Gysbert_Wassenaar — Wed, 13 Mar 2013 17:01:25 GMT

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.

Re: Can I add label to lines inside chart?

Wed, 13 Mar 2013 17:04:55 GMT

Works perfectly. Thanks

Re: Can I add label to lines inside chart?

Tue, 09 Apr 2013 13:53:49 GMT

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

Re: Can I add label to lines inside chart?

Tue, 10 Sep 2013 11:26:45 GMT

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 image

Re: Can I add label to lines inside chart?

chaudharic3333 — Thu, 26 Oct 2017 21:13:44 GMT

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