Using values from past reload

Thu, 07 Jul 2016 16:10:54 GMT

Hello,

Im currently trying to create a couple of objects that are practically the same.

With the type of data we get, we create a table that has the sale for each customer per month.

The thing is, that i want to create another table exactly the same, but with the information of last week, and since we only get month and year, we cant really use any date to get the week.

What i have in mind, is to create the same object, but that it only shows information from last reload, since we update the info once per week, this would be able to show the differences between weeks.

Any one know how i can do this? Or maybe have some expirience with similar issue?

thanks in advance,

Mario

Re: Using values from past reload

boorgura — Thu, 07 Jul 2016 17:35:15 GMT

You might want to save the data into a QVD, along with a new date field - something like update_date.

Re: Using values from past reload

Thu, 07 Jul 2016 17:46:52 GMT

thanks, so simple and yet so elegant

topic Re: Using values from past reload in QlikView

Using values from past reload

Re: Using values from past reload

Re: Using values from past reload