topic Re: Adding a dimension in a Expression in QlikView https://community.qlik.com/t5/QlikView/Adding-a-dimension-in-a-Expression/m-p/427827#M566754 <HTML><HEAD></HEAD><BODY><P>I assumed that the group name is '<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">g_Overall</SPAN>'. </P><P></P><P>Try this expression :</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">((SUM(TargetsPWD) * SUM(WorkingDays))*TotalEmployees)/</SPAN>COUNT(GetCurrentField(<STRONG style="color: #737373; background-color: #ffffff; font-family: Arial;">g_Overall</STRONG>))</P><P></P><P>I hope this helps!</P><P></P><P>Regards</P><P>MultiView</P></BODY></HTML> Tue, 13 Nov 2012 12:36:28 GMT Anonymous 2012-11-13T12:36:28Z Adding a dimension in a Expression https://community.qlik.com/t5/QlikView/Adding-a-dimension-in-a-Expression/m-p/427826#M566753 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>Ok so basically i have a Drill through bar graph it is grouped on g_Overall(Region,Branch,employee) Now i have the figures i need but i want to adda target which would be an expression something along the lines of </P><P></P><P>((SUM(TargetsPWD) * SUM(WorkingDays))*TotalEmployees)/COUNT(Dimension)</P><P></P><P>basically on top level i want to see the target divided by how many Regions there is then when i click on a region ti should change to target divided by how many branches there are etc </P><P></P><P>Is thsi possible ? any help would be greatly appreciated</P><P></P><P>Regards</P><P>Curt</P></BODY></HTML> Tue, 13 Nov 2012 10:55:59 GMT https://community.qlik.com/t5/QlikView/Adding-a-dimension-in-a-Expression/m-p/427826#M566753 2012-11-13T10:55:59Z Re: Adding a dimension in a Expression https://community.qlik.com/t5/QlikView/Adding-a-dimension-in-a-Expression/m-p/427827#M566754 <HTML><HEAD></HEAD><BODY><P>I assumed that the group name is '<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">g_Overall</SPAN>'. </P><P></P><P>Try this expression :</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">((SUM(TargetsPWD) * SUM(WorkingDays))*TotalEmployees)/</SPAN>COUNT(GetCurrentField(<STRONG style="color: #737373; background-color: #ffffff; font-family: Arial;">g_Overall</STRONG>))</P><P></P><P>I hope this helps!</P><P></P><P>Regards</P><P>MultiView</P></BODY></HTML> Tue, 13 Nov 2012 12:36:28 GMT https://community.qlik.com/t5/QlikView/Adding-a-dimension-in-a-Expression/m-p/427827#M566754 Anonymous 2012-11-13T12:36:28Z