topic Re: Reduce data loaded in QlikView

Reduce data loaded

Anonymous — Thu, 18 Feb 2016 03:18:23 GMT

Hello Everyone!

I know what Im goign to ask is possible as someone once told me but I dont know how.

Basically. I have a file with many raws, lets imagine each raw is a purchase order list and every column is more information about each order(date, country, etc).

Can I load all the table, to later create a simplified version of it(using the script), lets says total order per day, and eliminate all the previous data loaded, as I dont need so much detail, with the goal of making my report faster and lighter?

Hope the next image helps you get my question.

Re: Reduce data loaded

kaushiknsolanki — Thu, 18 Feb 2016 16:55:30 GMT

Hi,

Try to aggregate them like below script.

Load Date,

Country,

Count(Order#) as OrderQty

From xyx

Group by Date,Country

Regards,

Kaushik Solanki

Re: Reduce data loaded

settu_periasamy — Thu, 18 Feb 2016 16:57:36 GMT

Try this..

T1:
Load [Order #], Date, Country From Source;

NoConcatenate

Final:

Load Date,Country,Count([Order #]) as [Order Qty] Resident T1 Group by Date,Country;

Drop Table T1;