topic Re: Re: Aggr and Set analysis in QlikView

Aggr and Set analysis

linoyel — Mon, 10 Mar 2014 13:14:07 GMT

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

Re: Aggr and Set analysis

MK_QSL — Mon, 10 Mar 2014 13:15:19 GMT

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

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

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

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

Re: Aggr and Set analysis

linoyel — Mon, 10 Mar 2014 13:21:36 GMT

Hi Manish, in both of your answers AppRate isn't recognized, probably it's location is the expression in incorrect...

Re: Aggr and Set analysis

MK_QSL — Mon, 10 Mar 2014 13:26:55 GMT

Can you upload your sample file or sample data?

Re: Aggr and Set analysis

linoyel — Mon, 10 Mar 2014 13:29:14 GMT

I don't know how to upload file...

Re: Aggr and Set analysis

linoyel — Mon, 10 Mar 2014 13:41:35 GMT

Well, I figured it out

This worked:

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

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

Re: Aggr and Set analysis

MK_QSL — Mon, 10 Mar 2014 13:41:50 GMT

Use advanced editor... and add your file as an attachment...

Advance Editor option is available at the TOP RIGHT...

Re: Aggr and Set analysis

linoyel — Mon, 10 Mar 2014 13:48:35 GMT

Use advanced editor where? What is advanced editor?

Re: Aggr and Set analysis

MK_QSL — Mon, 10 Mar 2014 13:51:54 GMT

If you try to reply, you will find the screen where usually we write... search there.

Re: Re: Aggr and Set analysis

linoyel — Mon, 10 Mar 2014 13:58:21 GMT

Oh, I see! Thank you!

So uploading file is called "binary upload"? Or "binary upload" is something else?

Re: Re: Aggr and Set analysis

MK_QSL — Mon, 10 Mar 2014 14:15:45 GMT

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