Actuals vs Projected Chart

yashcena — Sat, 22 Sep 2018 08:35:19 GMT

Hi,

I have the following data in my data model:

Resource Name

Project Type

Project Name

Projected Hours

Projected Dollars

Actual Hours

Actual Dollars

I have ProjectedHours and ActualHours week-wise in my data model. I have taken the sum(ProjectedHours) and sum(ActualHours) directly in my attached sample data.

I want to show what is the Actuals for each resource (project-wise) against their Projections. I am able to create a chart with sum(Actuals) for each resource. But since the Projections are different for each resource for different projects, what object should I use to visualize this?

I'm open to all ideas!

Thanks,

YASH

topic Actuals vs Projected Chart in QlikView

Actuals vs Projected Chart