topic Re: Set Analysis (selection) in QlikView

Set Analysis (selection)

adiarnon — Mon, 13 Oct 2014 08:40:44 GMT

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?

Re: Set Analysis (selection)

tresB — Mon, 13 Oct 2014 08:51:53 GMT

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

Re: Set Analysis (selection)

PrashantSangle — Mon, 13 Oct 2014 09:03:21 GMT

Hi,

Use TOTAL keyword,

Regards,

Re: Set Analysis (selection)

adiarnon — Mon, 13 Oct 2014 09:04:29 GMT

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

Re: Set Analysis (selection)

Mon, 13 Oct 2014 09:05:13 GMT

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.

Re: Set Analysis (selection)

adiarnon — Mon, 13 Oct 2014 09:05:45 GMT

tnx,

cam you help me

where should i insert the total?

Re: Set Analysis (selection)

adiarnon — Mon, 13 Oct 2014 09:07:42 GMT

but i want that it will always bring somthing back!

Re: Set Analysis (selection)

Mon, 13 Oct 2014 09:17:08 GMT

Oh sorry missunderstanding.

You can use the Set Idetifier 1.

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

This means that every selection will be Ignored ...

Re: Set Analysis (selection)

adiarnon — Mon, 13 Oct 2014 09:24:10 GMT

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

Re: Set Analysis (selection)

Mon, 13 Oct 2014 09:58:20 GMT

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