topic Re: Actual vs Projected Hours Visualization in QlikView

Actual vs Projected Hours Visualization

yashcena — Thu, 19 Jul 2018 10:07:31 GMT

Hi,

I have the following columns in my data model:

The client wants these to be represented in this way:

The ProjectedHours is the base (green) and the ActualHour is in red. The visualization has to be in such a way that it represents that out of 240 projected hours, resource has charged 20 hours. Out of 200 projected hours, resource has charged 25 hours

I'm not able to get the baseline.It will be different for each project so putting it in the same chart is where I'm facing issue.

Any help would be appreciated.

Thanks,

YASH

Re: Actual vs Projected Hours Visualization

sunny_talwar — Thu, 19 Jul 2018 11:34:00 GMT

One of these charts? First chart is using the absolute values, whereas the second one is adding up to 100%

Re: Actual vs Projected Hours Visualization

BalaBhaskar_Qlik — Thu, 19 Jul 2018 11:41:13 GMT

Chart Type: Bar

Dimension - [Project Name]

Expressions:

Expr 1 - Sum([Actual Hours])

Click on - Background Color - Red().

Expr2 - Sum([Projected Hours])

Click on + - Background color - Green().

Style tab - Orientation - 2nd one, Subtype - Stacked.

Presentation tab - Show legend.

add other options, now check the created Stacked bar chart.

Re: Actual vs Projected Hours Visualization

sunny_talwar — Thu, 19 Jul 2018 11:44:14 GMT

I believe that will stack Actual over Projected causing the total stacking to cross above 240 for Alpha... the second expression should be [Projected Hours] - [Actual Hours].

Re: Actual vs Projected Hours Visualization

BalaBhaskar_Qlik — Thu, 19 Jul 2018 11:48:59 GMT

Yes.