topic Re: Get Total value from a Table in QlikView

Get Total value from a Table

Wed, 24 Jul 2013 09:29:39 GMT

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

Re: Get Total value from a Table

Wed, 24 Jul 2013 09:33:02 GMT

Hi,

FYR

Sum(Total Sales)

Regards,

Sukamal

Re: Get Total value from a Table

Wed, 24 Jul 2013 09:35:56 GMT

Sales is a new calculated column, so i can't find it from the Text Object 😕

Is there a way to get the Sales expression from outside of the table

Re: Get Total value from a Table

Wed, 24 Jul 2013 09:36:19 GMT

sum( total [Total Sales])

Re: Get Total value from a Table

Wed, 24 Jul 2013 09:37:03 GMT

Can you post an example, I will try to fix for you.

Re: Get Total value from a Table

Wed, 24 Jul 2013 09:41:51 GMT

I still don't have any visibility of my Sales Field

Re: Get Total value from a Table

Wed, 24 Jul 2013 09:44:45 GMT

Hi,

Then you used aggr function....

it will soved your problem.

Re: Get Total value from a Table

Wed, 24 Jul 2013 09:45:31 GMT

Get your document uploaded I'll do it for you quickly.

Re: Get Total value from a Table

Wed, 24 Jul 2013 09:45:39 GMT

Here is the example

Re: Get Total value from a Table

Wed, 24 Jul 2013 09:47:05 GMT

You're blocking out the column headings which I will need to build the expression. Move the white box so it's covering data only, not the column headings in your example table.

Re: Get Total value from a Table

Wed, 24 Jul 2013 09:50:53 GMT

Is it ok for you?

Re: Get Total value from a Table

Wed, 24 Jul 2013 09:56:13 GMT

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)

Re: Get Total value from a Table

Wed, 24 Jul 2013 11:32:35 GMT

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

Re: Get Total value from a Table

Wed, 24 Jul 2013 11:33:50 GMT

=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/

Re: Get Total value from a Table

Wed, 24 Jul 2013 11:45:50 GMT

You can find the table in the file attached..

I cannot tackle this problem.

Re: Get Total value from a Table

ariel_klien — Wed, 24 Jul 2013 12:04:53 GMT

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...

Ariel

Re: Get Total value from a Table

Wed, 24 Jul 2013 12:58:26 GMT

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...

Re: Get Total value from a Table

Wed, 24 Jul 2013 13:04:51 GMT

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