topic Comparing totals on different dates in QlikView

Comparing totals on different dates

kevinstanfield — Mon, 08 Feb 2016 18:08:05 GMT

Hi,

Hope you can help - I have a data set that is used(amongst other things) to calculate the size of a telephony customer base as at a date in time with the output being:

sum(total number of customers connected)-sum(total number of customers disconnected).

Each day the data refreshes to add in the number of customers connected on that date and the number of customers disconnected on that date i.e. so a new figure is calculated each day.

What I'm trying to achieve is how to compare the 2 most recent dates to indicate whether the customer base has increased/decreased since the data last refreshed.

Any views on how to achieve this?

Thanks in anticipation.

Kevin

Re: Comparing totals on different dates

Gysbert_Wassenaar — Mon, 08 Feb 2016 18:18:30 GMT

Perhaps like this:

=sum({<MyDate={$(=Max(MyDate))}>}total number of customers connected)-sum({<MyDate={$(=Max(MyDate))}>}total number of customers disconnected) - sum({<MyDate={$(=Max(MyDate)-1)}>}total number of customers connected) + sum({<MyDate={$(=Max(MyDate)-1)}>}total number of customers disconnected)

Re: Comparing totals on different dates

kevinstanfield — Tue, 09 Feb 2016 10:31:44 GMT

Thanks, I'll give it a go and get back to you.