topic Re: Sum Selected ListBox values in QlikView

Sum Selected ListBox values

Anonymous — Thu, 01 Jan 2015 17:09:05 GMT

Hi,

Can you tell me how to show sum of selected list box values in TextObject.

Screenshot is here,

regards,

Anonymous — Thu, 01 Jan 2015 17:39:26 GMT

Hi,

I think you should write just this: sum(distinct [Name_Field_in_listbox])

Elena

engishfaque — Thu, 01 Jan 2015 18:20:27 GMT

Dear Elena,

Sum(Distinct(FieldName)) will return the sum of field not list box selected values.

Kind regards,

Ishfaque Ahmed

Anonymous — Fri, 02 Jan 2015 08:57:25 GMT

The question is: "how to show sum of selected list box values in TextObject".

If these values are selected, sum function will return the sum of only the selected values...

Maybe, didn't I understand the question?

Thanks,

Elena

Anonymous — Fri, 02 Jan 2015 09:03:18 GMT

Hi,

Take sum(field_name) in text box.

HTH

Anonymous — Fri, 02 Jan 2015 09:26:19 GMT

=sum(distinct(value)) will return sum of selected values in listbox

'value' is column which is used in list box .