topic Re: Dual Function in a line graph in QlikView

Dual Function in a line graph

zagzebski — Tue, 08 Mar 2016 15:55:49 GMT

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

Re: Dual Function in a line graph

Digvijay_Singh — Tue, 08 Mar 2016 16:05:56 GMT

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.

Re: Dual Function in a line graph

Digvijay_Singh — Tue, 08 Mar 2016 16:06:37 GMT

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

Re: Dual Function in a line graph

zagzebski — Tue, 08 Mar 2016 16:28:21 GMT

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

Re: Dual Function in a line graph

Digvijay_Singh — Tue, 08 Mar 2016 16:36:31 GMT

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

settu_periasamy — Tue, 08 Mar 2016 16:47:17 GMT

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

Re: Dual Function in a line graph

zagzebski — Tue, 08 Mar 2016 16:47:28 GMT

Thanks for the help!

Simplified the chart. Still nothing..

Re: Dual Function in a line graph

Digvijay_Singh — Tue, 08 Mar 2016 16:57:50 GMT

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

Re: Dual Function in a line graph

Anonymous — Mon, 23 May 2016 16:13:43 GMT

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

Re: Dual Function in a line graph

settu_periasamy — Tue, 24 May 2016 09:51:02 GMT

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