https://community.qlik.com/t5/QlikView/Current-Vs-Previous/m-p/1597906#M737907 <P>Hi All.</P><P>Please find the attachment of the Qlikview file .</P><P>I have two bar charts, Current percentage and Preveious Percentage .</P><P>The first bar Chart ( Current percentage) is showing proper value. and the second chart<BR />is giving me wrong data for previous year Percentage &nbsp;.</P><P>If i see the by making selection from year filter the first chart show correct values on the selection<BR />&nbsp;.<BR />when i see the previous values for second chart (Previous Percentage they are different )<BR />Can you expertise please help me on this .</P><P>Thanks in Advance</P> Wed, 25 Nov 2020 16:16:04 GMT smilingjohn 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Current-Vs-Previous/m-p/1597906#M737907 <P>Hi All.</P><P>Please find the attachment of the Qlikview file .</P><P>I have two bar charts, Current percentage and Preveious Percentage .</P><P>The first bar Chart ( Current percentage) is showing proper value. and the second chart<BR />is giving me wrong data for previous year Percentage &nbsp;.</P><P>If i see the by making selection from year filter the first chart show correct values on the selection<BR />&nbsp;.<BR />when i see the previous values for second chart (Previous Percentage they are different )<BR />Can you expertise please help me on this .</P><P>Thanks in Advance</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Current-Vs-Previous/m-p/1597906#M737907 smilingjohn 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Current-Vs-Previous/m-p/1598841#M737908 <P>May be change your current year expression as</P><P>(count({&lt;[When Found]={'Production'},year={"$(=Max(year))"}&gt;}Key))/count(Key)</P> Wed, 03 Jul 2019 19:45:21 GMT https://community.qlik.com/t5/QlikView/Current-Vs-Previous/m-p/1598841#M737908 sasiparupudi1 2019-07-03T19:45:21Z