Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
cxclucas
New Contributor III

Reduce data loaded

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.

Screenshot_2.jpg

Tags (1)
2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Reduce data loaded

Hi,

Try to aggregate them like below script.

Load Date,

        Country,

        Count(Order#) as OrderQty

From xyx

Group by Date,Country

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted

Re: Reduce data loaded

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;