Current Vs Previous

[smilingjohn]

Hi All.

Please find the attachment of the Qlikview file .

I have two bar charts, Current percentage and Preveious Percentage .

The first bar Chart ( Current percentage) is showing proper value. and the second chart
is giving me wrong data for previous year Percentage  .

If i see the by making selection from year filter the first chart show correct values on the selection
 .
when i see the previous values for second chart (Previous Percentage they are different )
Can you expertise please help me on this .

Thanks in Advance

[sasiparupudi1]

May be change your current year expression as

(count({<[When Found]={'Production'},year={"$(=Max(year))"}>}Key))/count(Key)