sum of multi selected values in list box

[manoj217]

i have a text object  i want to show sum of all multi selected list box values into text object how can i achieve  that

[jaumecf23]

=sum(name_field)

[ahmar811]

Hi manoj,

I think jaume is right because if you want to sum of all selection you just put expression sum(field name).

or

but still you have problem so, just share some sample data with your scenario then we will provide our suggestion.

Regards

Ahmar

[zebhashmi]

yah looks like its just a sum(of_field) unless .....

[qlikwiz123]

Like everyone else said, Sum(Field_Name) should do and when the values are selected in the list box or even a Multi Select Box in your case, the Sum(Field_Name) changes with respect to those selected values. Let all of us know if that expression was of any help or your requirement is something else.

[manoj217]

i have taken a text object, initially i hv to show 0 in that while i am selecting the values in list box it have to add all those values and reflect in the text object

[avinashelite]

try like this

if(getselectedcount(field_name)=0,0,sum(value_field_name)

[manoj217]

Thanks avinash its working

[avinashelite]

cool if you have got the answer mark the correct and helpful answers and close this thread

[qlikview2018]

Ho do I create aa attached tables