Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
smilingjohn
Contributor III

Current Vs Previous Percentage

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Current Vs Previous Percentage

hi,

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

for previous 

 

With pleasure,

Andrei

View solution in original post

1 Reply
Partner
Partner

Re: Current Vs Previous Percentage

hi,

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

for previous 

 

With pleasure,

Andrei

View solution in original post