How to display a list with calculated values and add them?

[Anonymous]

Hello everyone! I'm new in Qlikview and i've had a question about how to crate a table that shows calculated information.

I have a table with the following information:

iD	Name	last Name	Department	Hours
1	Name 1	Last Name 1	Department 1	L1
1	Name 1	Last Name1	Department 1	M2
1	Name 1	Last Name1	Department 1	W2
2	Name 2	Last Name2	Department 1	L3
2	Name 2	Last Name2	Department 2	L4
3	Name 3	Last Name3	Department 3	V4

This table is loaded in Qlik and each value in the hour column is equivalent to 1. Now what I want to do is show a table with how many blocks each person makes according to the department and I do not know how to do it. In the end it would have to be a table of the following form if I select the department 1 like filter:

iD	Name	Last Name	Total Hours
1	Name 1	Last Name1	3
2	Name 2	Last Name2	1

And with that table list, I also need to show the sum of the values in the column total hours in any other box.

I hope I have been clear, I am attentive to your comments

Thank you very much in advance

Greetings to all!

[datagrrl]

I think you want a chart, then pick a straight table.

The Expression would be Count(Hours)

Then check that you want an Expression total (that is the default)

Let me know if this isn't what you want. I can add screen shots if needed.

[datagrrl]

I am struggling with what you mean by:

I also need to show the sum of the values in the column total hours in any other box.

Maybe you could mock it up.

[Anonymous]

Hello Randi,

Once I have the table created, using count, I need to add the values counted in the total hours column and display that value in a graph. For example the last table have the Name 1 with 3 and the Name 2 with 1, i want to show in the chart: department 1 = 4 hours