topic Re: sum from filetime in QlikView

sum from filetime

Mon, 30 Jun 2014 08:56:17 GMT

Hi All.

I have a many files from one directory.

I need sum values from last file and all other files.

How i can do it?

For example. I have 3 tables:

Table 1 (create 01-01-2014)

Table 2 (create 02-01-2014)

Table 3 (create 03-01-2014)

Name	Quantity
Name 1	10
Name 2	20

Name	Quantity
Name 3	30
Name 4	40

Name	Quantity
Name 5	50
Name 6	60

In the end I need next datas:

Thanks.

Gysbert_Wassenaar — Mon, 30 Jun 2014 09:07:01 GMT

Load all the data into one table and make sure you add the data into a field in that table too.

If necessary you can use the FileTime() function to retrieve the modification date of the file.

Once you have you can create a table with expressions to get the correct sums:

All: sum(Quantity)

Last: sum({<FileTime={'$(=max(FileTime))'}>} Quantity)

Earlier: All - Last

Mon, 30 Jun 2014 09:25:24 GMT

Gysbert, thank you! It's work