Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Group Calculation

Screenshot.png

In this table I am having trouble trying to calculate the Day 01 Weight column. If I select a certain group code it gives me the correct amount, but I need the table to give the correct amount by Group Cd without having to select one. Any help on this will be greatly appreciated. 

1 Solution

Accepted Solutions
JonnyPoole
Former Employee
Former Employee

hi there i downlowed your qvw and tried this. Does it work ?

Sum(Total <Project_#> fDay1_wt * Aggr(Sum(Head_Start), fDay1_wt,Project_#))

/

Sum(Total <Project_#> Aggr(Sum(Head_Start), fDay1_wt,Project_#))

View solution in original post

2 Replies
JonnyPoole
Former Employee
Former Employee

hi there i downlowed your qvw and tried this. Does it work ?

Sum(Total <Project_#> fDay1_wt * Aggr(Sum(Head_Start), fDay1_wt,Project_#))

/

Sum(Total <Project_#> Aggr(Sum(Head_Start), fDay1_wt,Project_#))

Anonymous
Not applicable
Author

Awesome job, thank you.