Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Dual Function in a line graph

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

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

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

View solution in original post

9 Replies
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
Creator
Creator
Author

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

Dual.png

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
Master III
Master III

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
Creator
Creator
Author

Thanks for the help!

Simplified the chart. Still nothing..

dual2.png

Digvijay_Singh

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

Anonymous
Not applicable

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

settu_periasamy
Master III
Master III

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