Problem with Pivot Table

Wed, 16 Nov 2011 21:09:14 GMT

Hi,

im having a problem to show some values in a pivot table. This is an example of what I want to do:

TABLE1:

Date	Number of Employees
01/01	50
15/01	55
04/02	60
12/02	58
16/02	55
05/03	45

I need to do a Pivot table that shows number of employees per month and days. The problem is that i dont know what expression to use to achieve this. If i look in days, expression [Number of Employees] works, but it doesnt work in month dimension. And it isn't possible to sum number of employees because i only need the last value of employees of every month (and even the same value in a possible year dimension).

It would be great if this can be solved without modifying the script.

Thanks for the help in advance.

Problem with Pivot Table

Thu, 24 Nov 2011 16:28:14 GMT

This worked for me:

firstsortedvalue ([Number of Employees],-Date)

topic Problem with Pivot Table in QlikView

Problem with Pivot Table

Problem with Pivot Table