Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
homersimpson
Creator III
Creator III

How to create new tables from existing data?

Hi,

i want to create new tables from existing data. The new tables will get the sum up of data from the last 3 month and create a new date.

How can i do it by script?

2017-01-16_22h01_53.jpg

regards,

sam

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

You could just load all tables and concatenate them within a single table and then by using a table-chart with product as dimension you could include a condition within the expression like:

sum({ Date = {">=01.01.2017<=31.03.2017"}>} Sales)

whereby it might be useful to add a master-calendar: How to use - Master-Calendar and Date-Values to your datamodel and to use then fileds like Month or YearMonthSeriellNumber to handle the dimensions and/or the conditions within the expressions.

- Marcus

swuehl
MVP
MVP

You can use any approach described in

Calculating rolling n-period totals, averages or other aggregations

The As-Of Table

edit:

Well, these do not actually create aggregated facts tables in your model, but should server the reporting needs.