Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
(count({<[When Found]={'Production'},year={"$(=Max(year)-1)"}>}Key))/count({<year={"$(=Max(year)-1)"}>}Key)
for previous
With pleasure,
Andrei
hi,
(count({<[When Found]={'Production'},year={"$(=Max(year)-1)"}>}Key))/count({<year={"$(=Max(year)-1)"}>}Key)
for previous
With pleasure,
Andrei