Aggr and Set analysis

[linoyel]

Hey,

I have the following expression in the table:

Sum (if(cctranzresponse=000,Sum,0)) / Sum(aggr(Max(First_Try_Amount),unique_num,Department,UpType,IsOnline))

Now I need to write the same expression but for the certain bookmark and country.

I tried this:

Sum ({AppRate * 1<BillingCountryKey = {191}>} if(cctranzresponse=000,Sum,0)) /

Sum({AppRate * 1<BillingCountryKey = {191}>} aggr(Max(First_Try_Amount),unique_num,Department,UpType,IsOnline))

This works only when BillingCountry 191 is selected, but I want the expression not to be dependent on user selections...

[MK_QSL]

Binary upload is when you want to use one qvw file in another qvw apps