https://community.qlik.com/t5/QlikView/What-is-wrong-in-the-expression/m-p/1589853#M443586 <P>Hi&nbsp;</P><P>I shared a sample data in attachments&nbsp;</P><P>As example data<BR />in Overview pivot have Large Claim<BR />and High claimant<BR />in year 2019 (report Year) we have Large Claim = 777,594 it is true because 777,594 &gt; 700,000(Large Claim)<BR />but High Claimant it is wrong because in 2019 we have 777,594 and in 2018(prior year) we have 1,633,221 but in High Claimant Overview pivot we have 11,483 it is wrong must show 1,633,221 on displays.</P><P>Please help.</P> Mon, 10 Jun 2019 06:02:12 GMT narumonK 2019-06-10T06:02:12Z https://community.qlik.com/t5/QlikView/What-is-wrong-in-the-expression/m-p/1589853#M443586 <P>Hi&nbsp;</P><P>I shared a sample data in attachments&nbsp;</P><P>As example data<BR />in Overview pivot have Large Claim<BR />and High claimant<BR />in year 2019 (report Year) we have Large Claim = 777,594 it is true because 777,594 &gt; 700,000(Large Claim)<BR />but High Claimant it is wrong because in 2019 we have 777,594 and in 2018(prior year) we have 1,633,221 but in High Claimant Overview pivot we have 11,483 it is wrong must show 1,633,221 on displays.</P><P>Please help.</P> Mon, 10 Jun 2019 06:02:12 GMT https://community.qlik.com/t5/QlikView/What-is-wrong-in-the-expression/m-p/1589853#M443586 narumonK 2019-06-10T06:02:12Z https://community.qlik.com/t5/QlikView/What-is-wrong-in-the-expression/m-p/1589951#M443587 <P>You want 1,633,221 for 2017, right? because I see 11,483 as Prior Year when 2018 is selected</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 834px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/13464iF7C199535C5EF69A/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Mon, 10 Jun 2019 11:36:16 GMT https://community.qlik.com/t5/QlikView/What-is-wrong-in-the-expression/m-p/1589951#M443587 sunny_talwar 2019-06-10T11:36:16Z