topic Totals over a Column in QlikView

Totals over a Column

Fri, 17 Dec 2010 11:59:40 GMT

Dear helper,

How can i get the subtotals from a Column (with multiple dimensions), to use in an another object?

Example column "Column 1":

A sum on all these results, to use on this radar chart:

A solution would be to save those column sum (on "Column 1") in a variable, i guess. I don't know how to do that though.

Any ideas? Thank you in advance!

Kind regards,

Roel Beun

Fri, 17 Dec 2010 12:08:50 GMT

If you want to use a variable, you can use set analysis to create the value you need.

=Sum({$<Dim1={...},Dim2={...}>} Column1)

Create a set by using the dimensions necessary to select all the values in Column1 you want to sumarize.

Fri, 17 Dec 2010 12:16:33 GMT

Hi,

Hope this helps

-Ravi Kumar

Fri, 17 Dec 2010 14:41:54 GMT

Thank you all for your replies.

Oke, iam getting somewhere now. When i use static data, my formula is working. Now i have in my load script the following:

SET

MaximaalAantalPunten = 4;

SET

TotaalAantalKenmerken = Count(kenmerk) * $(MaximaalAantalPunten);

In most cases TotaalAantalKenmerken holds the number 16.

When i put the 16 as a number in my previous mentioned formula i get as answer: 25

Formula:

Sum({$<dimensie={"Kennis/Product"}>} [Kenmerk waarde]) / 16 ) * 100

When i put in the variabel TotaalAantalKenmerken iam getting strange numbers. It says it holds the number 772 instead of 16

Formula:

=(Sum({$<dimensie={"Kennis/Product"}>} [Kenmerk waarde]) / TotaalAantalKenmerken ) * 100

=(Sum({$<dimensie={"Kennis/Product"}>} [Kenmerk waarde]) / $(TotaalAantalKenmerken) ) * 100

How can i get the variabel TotaalAantalKenmerken in my formula with the correct number, 16?

Wed, 22 Dec 2010 09:38:02 GMT

Thank you all for your response. The problem i mentioned in this thread has been solved with above suggestions.