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: 
consultant_bi
Creator
Creator

How to get the Sum of values selected in a filter pane

Hello everyone,

i am new to Qlik Sense , i am still learning but sometimes i'm just stuck, would someone give me help on this one

Sans titre4.png

well here i want to have the sum of the selected fields displayed on the text field on the right of the filter pane, i tried a lot of things but did not found out the solution, here is my formula :

Sum(GetfieldSelections([field]))


and thanks to everyone.



1 Solution

Accepted Solutions
sunny_talwar

I think all you need is this

Sum(FieldName) -> Sum(field)

View solution in original post

7 Replies
sunny_talwar

I think all you need is this

Sum(FieldName) -> Sum(field)

dwforest
Specialist II
Specialist II

To expand on Sunny's answer, this is how Qlik works... by default your measures will be calculated by the current selection.

jerryyang756
Creator
Creator

If(GetFieldSelections([Field]), Sum([Field]))

consultant_bi
Creator
Creator
Author

Thank you for your replies , so you mean i just need to write sum([FieldName]) without the function getfieldselections ?

i think i need to explain more may be , the filter pane in left it's a dimension field and what i want in the expression area of the text field in right which display the number "91110.." i am trying to display on it the sum of values selected on the filter pane on the left

sunny_talwar

If you want to sum values for your selected dimension value, all your need is to do Sum(Value) and everything else will be taken care of

dwforest
Specialist II
Specialist II

Yes, this is the whole point of Qlik...

Did you try it and see something different?

consultant_bi
Creator
Creator
Author

Hello,

i would like to thank everyone for the help, actually it worked fine.