Current Vs Previous Percentage

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Current Vs Previous Percentage

andrei_delta — Wed, 03 Jul 2019 10:08:05 GMT

hi,

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

for previous

With pleasure,

Andrei

topic Re: Current Vs Previous Percentage in QlikView

Current Vs Previous Percentage

Re: Current Vs Previous Percentage