https://community.qlik.com/t5/QlikView/Dual-in-Expression/m-p/1634283#M733180 <P>First of all, Dual() takes two parameters and I think I only see one on your expression.</P><P>I suggest you break down the expression into smaller pieces and determine what s working and what is not.&nbsp;</P><P>-Rob</P> Fri, 11 Oct 2019 13:15:07 GMT rwunderlich 2019-10-11T13:15:07Z https://community.qlik.com/t5/QlikView/Dual-in-Expression/m-p/1634275#M733179 <P>Dear Community</P><P>&nbsp;</P><P>I am having not output with the below:</P><P>=dual( Sum(({&lt;Year={$(=max(Year))},MONTH={$(=MONTH(LatestDate))}&gt;}$(vMeasure))/1000) &amp; ' (' &amp; num((sum({&lt;Year={$(=max(Year))},MONTH={$(=MONTH(LatestDate))}&gt;}$(vMeasure))/sum({&lt;Year={$(=Year(LYY))},MONTH={$(=MONTH(LYM))}&gt;}$(vMeasure)))-1,'##.0%'))</P><P>&nbsp;</P><P>Can I please ask for some guidance&nbsp;</P><P>&nbsp;</P><P>Regards</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Dual-in-Expression/m-p/1634275#M733179 george456 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Dual-in-Expression/m-p/1634283#M733180 <P>First of all, Dual() takes two parameters and I think I only see one on your expression.</P><P>I suggest you break down the expression into smaller pieces and determine what s working and what is not.&nbsp;</P><P>-Rob</P> Fri, 11 Oct 2019 13:15:07 GMT https://community.qlik.com/t5/QlikView/Dual-in-Expression/m-p/1634283#M733180 rwunderlich 2019-10-11T13:15:07Z