is a variable can store multiple values?

[#1]

Hi All

I am facing an issue in the following scenario can any one guide me,

I Have Two tables ,

One is having Fields like EmployeeID,Period

Second is having Employee ID ,Cost

now I Want to calculate Principle amount in second table period wise, like

count(EmployeeID)*AVG(Cost)[ here count(employee count is for Period)] how to do this.

[Peter_Cammaert]

QlikView will do it for you.

Make sure that the two tables connect (change one of the EMployeeID fields tro match the other). Then create a straight table, add a single Dimension Period and an expression =count(DISTINCT EmployeeID) * avg(cost) or simply =sum(cost) which is essentially the same.