Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

kevinstanfield
New Contributor III

Comparing totals on different dates

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

1 Solution

Accepted Solutions

Re: Comparing totals on different dates

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)




talk is cheap, supply exceeds demand
2 Replies

Re: Comparing totals on different dates

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)




talk is cheap, supply exceeds demand
kevinstanfield
New Contributor III

Re: Comparing totals on different dates

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

Community Browser