Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
I think all you need is this
Sum(FieldName) -> Sum(field)
To expand on Sunny's answer, this is how Qlik works... by default your measures will be calculated by the current selection.
If(GetFieldSelections([Field]), Sum([Field]))
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
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
Yes, this is the whole point of Qlik...
Did you try it and see something different?
Hello,
i would like to thank everyone for the help, actually it worked fine.