Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

zagzebski
Contributor

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

Re: Dual Function in a line graph

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
Honored Contributor III

Re: Dual Function in a line graph

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
Honored Contributor III

Re: Dual Function in a line graph

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

zagzebski
Contributor

Re: Dual Function in a line graph

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

Dual.png

Digvijay_Singh
Honored Contributor III

Re: Dual Function in a line graph

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.

Re: Dual Function in a line graph

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

zagzebski
Contributor

Re: Dual Function in a line graph

Thanks for the help!

Simplified the chart. Still nothing..

dual2.png

Digvijay_Singh
Honored Contributor III

Re: Dual Function in a line graph

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

Highlighted
deddy_taslim
New Contributor II

Re: Dual Function in a line graph

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

Re: Dual Function in a line graph

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