Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Qlikview Sum to Higher Level Dimension

Hello, 

Please see the attached screenshot providing details of the below question.

I currently have a table at a lower dimension of States representing tickets and weeks in two different columns. For each state (row), I multiply the #of tickets by the # of weeks to get a total. I then have a sum of at the top. 

My question is, how can I get the same totals at a higher level dimension (Country)? 

Tickets =  Sum(Tickets)

WKS = Sum(WKS)

Tickets x WKS = Sum(Tickets) x Sum(WKS)

Since in the second table I am removing the dimension of State, all that is left is one row with one summed value of tickets, and one summed value of WKS. Multiplying those two values however, produces a sum that is larger than expected output. 

Any help is greatly appreciated.

Regards

Labels (4)
3 Replies
Highlighted
Partner
Partner

It sounds to me like you are looking for an average Sum(Tickets) x Sum(WKS) per some kind of dimension combination. E.g. Colour and week. To accomplish that you will need to use the aggr functionality.

AVG(AGGR(Sum(Tickets) x Sum(WKS), Color, WKS))


Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Partner
Partner

I would also recommend you to look at the alternative KPI tickets per week.

Sum(Tickets) / Sum(WKS)

This expression will scale well even when changing to higher level dimensions.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Contributor III
Contributor III

Hi Vegar,

Thank you for your help, again!

While your suggestions did not directly provide the solution to my problem, they better helped me understand what I am trying to do, as well as the exact problem I am running into. That being the case, I opened a separate question on my problem here: https://community.qlik.com/t5/New-to-QlikView/Taking-the-Sum-of-an-already-summed-expression/m-p/156....

 

Thank you again