topic Re: Using aggregation funuctions in Script in QlikView

Using aggregation funuctions in Script

Thu, 10 May 2012 12:49:17 GMT

i am using sum and count functions in my script, but it gives me error like invalid functions. So i just want to know is, can use use these functions in script and if yes then can some one share some syntax of using them with an if statement.

Using aggregation funuctions in Script

Thu, 10 May 2012 13:01:11 GMT

you can, but you need to do a group by with a resident table.

Re: Using aggregation funuctions in Script

Miguel_Angel_Baeyens — Thu, 10 May 2012 14:35:35 GMT

Hi,

Elaborating a bit on what Marc aptly suggests, the script should look like the following:

AllData_Temp:
LOAD Country,
     CustomerID,
     Value,
     Discount,
     NewCustomer
FROM Customers.qvd (qvd); // or whatever other data source here
// Sum and Count when NewCustomer = 1
AggregatedData:
LOAD Country, 
     Sum(If(NewCustomer = 1, Value, 0)) AS CountryValue,
     Sum(If(NewCustomer = 1, Discount, 0)) AS CountryDiscount
RESIDENT AllData_Temp
GROUP BY Country;
DROP TABLE AllData_Temp;

Hope that helps.

Miguel

Re: Using aggregation funuctions in Script

Tue, 23 Apr 2013 17:59:48 GMT

Works perfectly. Please mark it as answers so others can benefit....

Re: Using aggregation funuctions in Script

evan_kurowski — Tue, 15 Apr 2014 21:03:16 GMT

As an addition to this.. if all you are requesting are aggregation expression results, no group by or dimension fields are required.

Data_Range:

LOAD

Min(Date) AS Earliest_Data_Date

,Max(Date) AS Latest_Data_Date

RESIDENT Fact_Table;

Re: Using aggregation funuctions in Script

Anonymous — Tue, 15 Apr 2014 21:03:57 GMT

The post on this thread from Evan Kurowski was accidentally. In order to restore points to all participants I have copied and reinserted this comment. Thanks for your patience!

"Script Execution Progress" window hangs