I like to have an total of more weeks in linechart

[francisvandergr]

Hi,

I like to have totals in linechart from more weeks. Is this possible ?

i included an good example with clear explanation

[swuehl]

Maybe like attached?

[francisvandergr]

It works for my example. Bit in real i use set analyse.

Now i like to use to combine in Set analyses. See all directors but not Director 'AAAA'

[francisvandergr]

See attachment example3

[swuehl]

Not sure what Director 'AAAA' is in your sample data file, can't find a field like this.

Have you tried adding the set expression like

{<Director -= {'AAAA'}>}

to all aggregation functions (and replacing single field references with Only({<Director -= {'AAAA'}>}  FieldName) )

[Anonymous]

for Project not AAAA try:

sum({<Project-={'AAAA'}>}Amount)/Count({Project-={'AAAA'}distinct Project)

you may include those which you donot want into a variable and place the variable in expresssion

[francisvandergr]

I get not the right values. You have seen my attachment Example_Simple_3.qvw

[swuehl]

Would be good to see an example with your required results for a chosen director (I've now found the Director field, but no 'AAAA' value).

Maybe like attached using

=Rangesum(Above(sum({$<Director -= {Bert}>}Amount) ,0,Rowno() ))  /

rangesum(above(count(aggr( Only({$<Director -= {Bert}>}Project),Project) ), 0 ,RowNo() ))

[francisvandergr]

Here i send you my original qvw. I describe my problem in two steps on the 2 worksheets.

I think we are close but we have not the result we want. I hop you can help me

[swuehl]

On the first sheet, try

(Rangesum(Above(sum({$<Project_Projectleider -= {'Bert Schilt'}>}Project_Aanneemsom) ,0,Rowno() )) +

Rangesum(Above(sum({$<Project_Projectleider -= {'Bert Schilt'}>}Meerwerk_Bedrag)    ,0,Rowno() )))

/

rangesum(above(count(aggr(Only({$<Project_Projectleider -= {'Bert Schilt'}, Project_Code = {"=Sum ({<Jaar = {$(=max(Jaar))}>}Project_Aanneemsom)"}>} Project_Code), Project_Code)) , 0 ,RowNo() ))

I must admit I haven't fully understood the issue on sheet 2.