topic Re: Graph Help in QlikView

Graph Help

Sat, 31 Jan 2015 13:16:28 GMT

Hi!

I’m trying to create a table with the following expressions:

Month
Working Hours
Monthly Cost: sum fields cost1, cost2 and cost3;
Charge per Hour: monthly cost / working hours

This should appear in this way from January 2013 to December 2013:

Repart

Employee

Contract

2013

January

Working Hous

Charge per Hour

Monthly Cost

December

Working Hous

Charge per Hour

Monthly Cost

Total

You can find an example attached.

Do you think maybe it’s possible also to do a graph in this way?

Any suggestions greatly appreciated.

Andrea

Re: Graph Help

jonasheisterkam — Sat, 31 Jan 2015 13:48:50 GMT

Hi, is this what you need?

Re: Graph Help

Sat, 31 Jan 2015 15:50:57 GMT

Hi, is it possible to place month fields horizontally for each employee?

In your example, when an employee worked in the same month, but in different years, costs are summed?

Thank you for in advance for your time!

Re: Graph Help

jonasheisterkam — Sat, 31 Jan 2015 16:07:21 GMT

No i think not there are Sumed over years. I define the Dim of Your to be only 2013 if you use all Years you get a Month values every year. It is interactiv Pivot you can change alle this vith drag drop on the Dim caption. If you want shure that it is not calculating over the Years you can use monthname.

here is the file again without only showing 2013.