topic Re: List box value sum up. in QlikView

List box value sum up.

Thu, 19 Sep 2013 13:16:10 GMT

I have 2 list boxes.one with amount and another with region values.In amount list box I have amount day by day.How can I sum up that amount as one big amount for 1 region?

Can anybody help me please?

Thanks for all your help.

Re: List box value sum up.

CELAMBARASAN — Thu, 19 Sep 2013 13:57:12 GMT

May be something like

Aggr(Sum(Amount), Region)

or Go to the expression tab of the Region list box and write expression as Sum({<Region=>} Amount)

Re: List box value sum up.

tresB — Thu, 19 Sep 2013 13:59:41 GMT

Select a region form list box. Create a text box and put expression there like: =Sum(YourAmountField)

Or,

If you want for a specific region, right expression in textbox like:

=Sum(If(RegionField='Region1',AmountField))

Or,

Take a staright table, RegionField as a dimension, and expression as :=Sum(Amount)

Re: List box value sum up.

jduenyas — Thu, 19 Sep 2013 19:25:54 GMT

I do not think you can sum numbers in a List Box. As its name says it is only a list.

For summing up numbers you need a chart object such as a Straight Table or a Pivot Table.

You can display totals as a single value in a text box that has an expression in the text area.

In a Straight or Pivot table put your Region as a dimension and =Sum(AmountField) in the expression.

Re: List box value sum up.

jduenyas — Thu, 19 Sep 2013 19:43:07 GMT

I would like to correct my previous statement.

You can display the summed up amount in the Title area.

You can enter as a title a formula like this: = Num(Sum(AmountField),'$#,###.##) and the total will be displayed in the title. If you are clever and manipulate the expression more you can even add/append the text of the selected Region to the Title with the total. (Something like this: = 'Region - ' & RegionField & ' = ' & Num(Sum(AmountField),'$#,###.##)