Solved: Need help with YOY% in a bar chart - Qlik Community

Anonymous · ‎2016-10-04

Hi,

I have a bar chart in which YOY% between 2015 and 2016 Outlook is not being displayed right.

Attached is my qvw. Can some one please help me fix this ASAP. Thanks!

YOY% between 2015-2016 Outlook should be 93% (92.7)

sunny_talwar · ‎2016-10-04

It was an issue with your variable vOutlook, its fixed now

sunny_talwar · ‎2016-10-04

How are you calculating 93%?

Anonymous · ‎2016-10-04

‌Hi Sunny,

i'm doing ((current year - previous year)/previous year)*100

((2016 outlook - 2015)/2015)*100 which is ((2.18 - 30.01)/30.01)*100

sunny_talwar · ‎2016-10-04

Can you reattach the qvw file? I don't see it attached

Anonymous · ‎2016-10-04

Sorry I missed the attachment.

I attached it now...

sunny_talwar · ‎2016-10-04

It was an issue with your variable vOutlook, its fixed now

Anonymous · ‎2016-10-05

... Thanks much Sunny!

Need help with YOY% in a bar chart