Current Vs Previous Percentage

[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

[andrei_delta · Accepted solution]

hi,

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

for previous 

With pleasure,

Andrei