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

Value and Total value in the ser

Hi - I am trying to get % of total goals as additional column. I am trying to get the sum of total count using below expression, but I am not getting the exact total value. Am I missing something here?

({<GOAL_MEM_RNK={1}, GOAL_COMP_DT ={"=Len(GOAL_COMP_DT)>0"} >} {1} Rnk)

Untitled.png

1 Solution

Accepted Solutions
Not applicable
Author

What does the field Rnk represent? Is there a reason you cannot use Sum(TOTAL Cnt) from your table above?  But perhaps I am oversimplifying your issue.

View solution in original post

3 Replies
Not applicable
Author

correct expression:  SUM({<GOAL_MEM_RNK={1}, GOAL_COMP_DT ={"=Len(GOAL_COMP_DT)>0"} >} {1} Rnk)

Not applicable
Author

What does the field Rnk represent? Is there a reason you cannot use Sum(TOTAL Cnt) from your table above?  But perhaps I am oversimplifying your issue.

Not applicable
Author

Thanks Rebecca. Adding TOTAL solved this problem..