Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum while Ignoring selection

Good day all,

I am trying to calculate the percentage of GP a selected field contributes to the total GP but do no know how to ignore the selection when calculating the Total GP.

Thank you for your help.

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

If you use set analysis then

Sum({$ <myField=>} value) -> with this sysntax you do not consider selectios of the field myField.

Sum({1} value) -> in this way you do not consider all the selections

View solution in original post

1 Reply
alexandros17
Partner - Champion III
Partner - Champion III

If you use set analysis then

Sum({$ <myField=>} value) -> with this sysntax you do not consider selectios of the field myField.

Sum({1} value) -> in this way you do not consider all the selections