Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Weighted Average drill down from Year to Quarter

Can somebody please help with a requirement that I have to implement ‘weighted average’ – I can get this to work at the Year level but I can’t get the drill down to the Quarter level to work.

See screen shot and qvw attached

WA_Year_Qtr.jpg

4 Replies
maxgro
MVP
MVP

perhaps

WA calc 1:

sum(TOTAL <Year_Date, Quarter_Date> [Emp Count])

qlikpahadi07
Specialist
Specialist

Find the attachment

Not applicable
Author

That has brought us a little bit closer but there is still a small issue which I am hoping that you can figure out:

WA_Total.jpg

qlikpahadi07
Specialist
Specialist

Hi Haynes,

well your above Chart is aggregating with Band,Quarter_Date but your Second chart is aggregating with Band,Year_Date.

As your first Chart contain Quarter as Dimension so that chart will automatically get aggregated with Quarter.

Solution

1. for your out put I can suggest you to create a Chart with Brand as Dimension  (Chart 2) and give Year and Quarter as selection.

2.if you see the output of first chart is also correct as per Qlikview Sum total which gives you 2.02 ,0.234..... but instead of sum you need sum total aggregated by Year so you need to create a Dynamic/Static Dimension with set analysis/valuelist () to obtain the same.

see examples for ValueList() in community

http://community.qlik.com/message/410626#410626