Dual Function in a line graph

[zagzebski]

I want to use the dual function to put a label by each line in the attached line graph. Having the legend on the right is to hard to follow.

I would like to have the label at the far right of each line. I assume I can use the dual function for this (I know I have seen this done before but can't find the reference.

Zag

[Digvijay_Singh]

Add new expression similar to  - Dual(If(Date=Max(total Date), <field to be displayed>, ' '),Sum(Sales))

Deselect show legend in presentation and Values on Data points in expression.

Dont set no format for expression else Dual won't work.

[Digvijay_Singh]

I meant Select 'Values on Data points' in expression.

[zagzebski]

I think I did what you suggested, but still no label...

[Digvijay_Singh]

Seems you have many other things involved could be making difference here. Try it with sample data and then see how it can be incorporated. I will see if I can share sample here.

[settu_periasamy · Accepted solution]

Try this

Dual(If(YearQuarterfield=Max(total YearQuarterField), 'Yourvalue, ''),Expression )

Number format should be expression default..

Check here

Qlik Tips: Lose the Legend in Line Charts

[zagzebski]

Thanks for the help!

Simplified the chart. Still nothing..

[Digvijay_Singh]

See this attached sample, may be I am missing the req.

[Anonymous]

I need someone to explain the logic of this Dual statement here, thanks!

[settu_periasamy]

Hi Deddy,

In the above expression, if the value reached the Maximum value, the text will display..

you can check the below links with example..

QlikView Addict: QlikView Functions: dual()

The Nature of Dual() Flags | Qlikview Cookbook