Get Total value from a Table

[#1]

Hello, i have a simple question but i cannot manage to do it..

I have a table with columns: ID , Sales ( value is 1 or 0 )

On the top of the table, there are automatic TOTAL rows which print the good value.

Here comes my issue, i would like to get the Total value and display it in a Text Object for example.

Is it possible to do it?

Thank you in advance

please find attached an example picture, i would like the total value 13 instead of 1515

[#2]

Is it ok for you?

[#3]

Your language isn't my native, so check the spellings. This is working for me though with my example data.

=aggr(sum(total Sales), Ressource, [Charge consommée], [Charge restante], Absences)

[#4]

Can you show me it working on a qv file please? It cannot find the sales field .

On my table, Ressource is a Dimension and the others are expressions, does the problem is here?

Thanks for your help

[#5]

=aggr(ADD YOUR TOTAL SALES EXPRESSION HERE, ADD YOUR DIMENSION HERE.)

I will try get a QVW for you after my lunch. edit: Would be helpful if you can scramble your data and upload your QVW, that way we can't see any of your companies data.

Google for scramble data in QlikView/

[#6]

You can find the table in the file attached..

I cannot tackle this problem.

[ariel_klien]

Hi,

You can use aggr() function (like wallerjc suggested)  or use Macro:

Create a variable = vNoRowCH01

CH01 is the Object ID - you can see/change it in Chart properties > General

Sub NoofRowsCH01

  set table = ActiveDocument.GetSheetObject("CH01")

  rows =  table.GetRowCount - 1

'msgbox "Number of Rows in Straight table is " & rows

  ActiveDocument.Variables("vNoRowCH01").SetContent rows, True 

End Sub

Then use the variable...

BR

Ariel

[#8 · Accepted solution]

hi mate sorry i went for lunch. Check out the attached, let me know if you want it explaining.

edit: it was very difficult working with names I couldn't read! the amount of typos i made in the expressions was not even funny...

[#9]

Thank you a lot my friend, French is not so easy !!!