Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Adding a dimension in a Expression

Hi Guys,

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

((SUM(TargetsPWD) * SUM(WorkingDays))*TotalEmployees)/COUNT(Dimension)

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

Is thsi possible ? any help would be greatly appreciated

Regards

Curt

Tags (2)
1 Reply
multiview
Contributor II

Re: Adding a dimension in a Expression

I assumed that the group name is 'g_Overall'.

Try this expression :

((SUM(TargetsPWD) * SUM(WorkingDays))*TotalEmployees)/COUNT(GetCurrentField(g_Overall))

I hope this helps!

Regards

MultiView

Community Browser