topic Re: Set Analysis in QlikView

Set Analysis

Mon, 17 Oct 2011 13:26:35 GMT

Helle Community,

I have read the tutorial to set analysis of Tom Mackay. Unfortunately I did not become really smart to solve my problem .

How can I aggregating the below table is always the sum of the 12 months in the chart?

Calculation of the values in Table 1-12 sums 20253.88 etc... see disired table.

Thank you !

Set Analysis

swuehl — Mon, 17 Oct 2011 13:50:54 GMT

I think you could just use a sum with appropriate total qualifier:

I assume you have three dimensions in your chart like Dim1, Dim2, Dim3 (where Dim1 has values like F&C, Dim2 like Personalaufwand... and Dim3 are the Months).

Then you could use

sum(total<Dim1,Dim2> VALUEFIELD)

where VALUEFIELD is the field containing the numbers your blue and green values are based on.

Hope this helps,

Stefan

Re: Set Analysis

Mon, 17 Oct 2011 14:22:59 GMT

Hi Stefan,

Thank you for your support. I have five dimensions in my diagram. I tried your example like:

In the diagram there are five dimensions. I tried your example on the following:

sum(total< PD_OBERBEREICH, PD_KOSTENGRUPPE, PD_CAROTKONTONAME> PD_WERT )

But the values are not always correct. See Screenshot

Or see my qvw file

Re: Set Analysis

swuehl — Mon, 17 Oct 2011 14:34:17 GMT

One question:

why do you divide your sum 1-12 months by 10?

I noticed that you have several records per combination of your dimensions, sometimes 10, sometimes 5, sometimes more than 10.

Maybe try this:

sum(total< PD_OBERBEREICH, PD_KOSTENGRUPPE, PD_CAROTKONTONAME> PD_WERT ) / count(PD_WERT)

to get an average value.

Stefan

Re: Set Analysis

Mon, 17 Oct 2011 14:56:54 GMT

Hi Stefan,

many thanks for the tip. Now it fits.

I thought at first that the number formatting deviates one decimal place.

But you have correctly identified the problem. The records are more than 5 or 10 times, therefore the correct solution is to divide by the quantity.

Thanks again