topic is a variable can store multiple values? in QlikView https://community.qlik.com/t5/QlikView/is-a-variable-can-store-multiple-values/m-p/810287#M286033 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I am facing an issue in the following scenario can any one guide me,</P><P></P><P>I Have Two tables ,</P><P>One is having Fields like EmployeeID,Period</P><P>Second is having Employee ID ,Cost</P><P></P><P>now I Want to calculate Principle amount in second table period wise, like</P><P></P><P>count(<SPAN style="font-size: 13.3333330154419px;">EmployeeID</SPAN>)*AVG(<SPAN style="font-size: 13.3333330154419px;">Cost</SPAN>)[ here count(employee count is for Period)] how to do this.</P></BODY></HTML> Mon, 02 Feb 2015 18:45:38 GMT 2015-02-02T18:45:38Z is a variable can store multiple values? https://community.qlik.com/t5/QlikView/is-a-variable-can-store-multiple-values/m-p/810287#M286033 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I am facing an issue in the following scenario can any one guide me,</P><P></P><P>I Have Two tables ,</P><P>One is having Fields like EmployeeID,Period</P><P>Second is having Employee ID ,Cost</P><P></P><P>now I Want to calculate Principle amount in second table period wise, like</P><P></P><P>count(<SPAN style="font-size: 13.3333330154419px;">EmployeeID</SPAN>)*AVG(<SPAN style="font-size: 13.3333330154419px;">Cost</SPAN>)[ here count(employee count is for Period)] how to do this.</P></BODY></HTML> Mon, 02 Feb 2015 18:45:38 GMT https://community.qlik.com/t5/QlikView/is-a-variable-can-store-multiple-values/m-p/810287#M286033 2015-02-02T18:45:38Z Re: is a variable can store multiple values? https://community.qlik.com/t5/QlikView/is-a-variable-can-store-multiple-values/m-p/810288#M286034 <HTML><HEAD></HEAD><BODY><P>QlikView will do it for you.</P><P></P><P>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 <SPAN style="font-family: 'courier new', courier;">=count(DISTINCT EmployeeID) * avg(cost)</SPAN> or simply <SPAN style="font-family: 'courier new', courier;">=sum(cost)</SPAN> which is essentially the same.</P></BODY></HTML> Mon, 02 Feb 2015 22:02:06 GMT https://community.qlik.com/t5/QlikView/is-a-variable-can-store-multiple-values/m-p/810288#M286034 Peter_Cammaert 2015-02-02T22:02:06Z