Set Analysis (selection)

[adiarnon]

hi,

i have this expression-

COUNT({<PROJECT={"=Aggr(Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}ActualCurrentBook_$(vFinanceFormula)),PROJECT)>0
and
Aggr(Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}ActualCurrentBook_$(vFinanceFormula))/Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}BudgetCurrentBook_$(vFinanceFormula)),PROJECT)>=1"}
>}DISTINCT PROJECT)

the expression is working!

but i whant that if im making a selection in a field (like PROJECT) The expression will ignor the selection

how can i do that?

[tresesco]

I would suggest to check if the Aggr() within the set is really giving you the expected output. I would be doubly sure of this is right at all. Once you get rid if this aggr(), may be by just including 'PROJECT=' in the max() (probably) that you use in variable vMaxBudgetVersion definition.

If you are in doubt, try to create a qvw with sample data and share here (and, please don't forget explain your expected output against that data).

[PrashantSangle]

Hi,

Use TOTAL keyword,

Regards,

[adiarnon]

hi,

i cheked the aggr and its working!

about the - vMaxBudgetVersion ITS A VARIABLE that contain string not an expression.

so, i dont think its the solution.

i thought about like the $ (current selection) and 1 (all values)

but i sont know if its possible and if it is so where should it be,...

[#5]

Try this

COUNT($(=if(len(getfieldselection(PROJECT))=0,'{<PROJECT={"=Aggr(Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}ActualCurrentBook_$(vFinanceFormula)),PROJECT)>0
and
Aggr(Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}ActualCurrentBook_$(vFinanceFormula))/Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}BudgetCurrentBook_$(vFinanceFormula)),PROJECT)>=1"}
>}','')) DISTINCT PROJECT)

You check if the Project have a selected field, than you give the Setanalysis otherwise it will give back a empty string.

[adiarnon]

tnx,

cam you help me

where should i insert the total?

[adiarnon]

but i want that it will always bring somthing back!

[#8]

Oh sorry missunderstanding.

You can use the Set Idetifier 1.

count({1<Pro....> Distinct PROJECTS)

This means that every selection will be Ignored ... 

[adiarnon]

I TRIED-

COUNT({1<PROJECT={"=Aggr(Sum({1<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}ActualCurrentBook_$(vFinanceFormula)),PROJECT)>0
and
Aggr(Sum({1<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}ActualCurrentBook_$(vFinanceFormula))/Sum({1<[BUDGET VERSION]={$(vMaxBudgetVersion)},PROJECT=>}BudgetCurrentBook_$(vFinanceFormula)),PROJECT)>=1"}

>}  DISTINCT PROJECT)

NOT WORKING =(

[#10]

May you can provide your QVW, than it would be easier to help ...